Select Query Help...
| From: | Michael Knauf/Niles | Date: | Tue, 10 Dec 2002 19:53:51 +0000 |
| Subject: | Select Query Help... | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-24030@lists.php.net to get a copy of this message | ||
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