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

Reply via email to