This should work as well (newer syntax) ?: SELECT F.question, F.answer FROM Faqs AS F LEFT JOIN FaqsRelatedToProducts AS FP ON F.faqid = FP.faqid WHERE fgnumber = '$yourfgnumber'
Use: SELECT DISTINCT ... when your FaqsRelatedToProducts table includes identical "fgnumber-faqid" rows. :) Hynek -----Original Message----- From: Ignatius Reilly [mailto:[EMAIL PROTECTED]] Sent: 10. prosince 2002 23:42 To: [EMAIL PROTECTED]; Michael Knauf/Niles Subject: Re: [PHP-DB] Select Query Help... 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" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> 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 > > -- 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
