>-Original Message-
>From: shawn.gr...@sun.com [mailto:shawn.gr...@sun.com]
>Sent: Saturday, April 11, 2009 3:50 PM
>To: Jerry Schwartz
>Cc: mysql@lists.mysql.com
>Subject: Re: LEFT JOIN with third-table key
>
>Jerry Schwartz wrote:
>> This is a question
Jerry Schwartz wrote:
This is a question that I run into frequently; I might even have posted it
before.
If I have three tables:
A: pub_product_id
B: product_id, publisher_id, pub_product_id
C: publisher_id, publisher_code
D: product_id, product_price
and I want to find those `pub_products` th
This is a question that I run into frequently; I might even have posted it
before.
If I have three tables:
A: pub_product_id
B: product_id, publisher_id, pub_product_id
C: publisher_id, publisher_code
D: product_id, product_price
and I want to find those `pub_products` that are in A, but might o