ToProducts 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
TED]>
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
&g
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 re