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: 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 > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
