Select Query Help...

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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


[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux