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