Re: Select Query Help...
| From: | Ignatius Reilly | Date: | Tue, 10 Dec 2002 22:41:36 +0000 |
| Subject: | Re: Select Query Help... | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-24043@lists.php.net to get a copy of this message | ||
Try:
SELECT DISTINCT F.question, F.answer
FROM Faqs AS F, FaqsRelatedToProducts Table AS FP
WHERE F.faqid = FP.faqid
DTH?
Ignatius
____________________________________________
----- Original Message -----
From: "Michael Knauf/Niles" <mknauf@nilesaudio.com>
To: <php-db@lists.php.net>
Sent: Tuesday, December 10, 2002 8:53 PM
Subject: [PHP-DB] Select Query Help...
>
> select query question
>
> OK, I have 3 tables
>
> Products Table
> prodid
> fgnumber
> name
> description
>
> Faqs Table
> faqid
> question
> answer
>
> FaqsRelatedToProducts Table
> fpid
> fgnumber
> faqid
>
> I want to select all the faq question and answer pairs that relate to an
> fgnumber so I need to use both the Faqs table and the
FaqsRelatedToProducts
> table, how do I make that work?
>
> Michael
>
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>