Thanks,
This worked exactly like I had hoped.
Grant
Peter Brawley <[EMAIL PROTECTED]> wrote: Grant,
>If I want to select all the products that are in the product_table,
>but not in the sale_table, how to make the query? The product_table
>has all the products, but the sale table is a subset of the product_table.
SELECT * FROM product_table p
LEFT JOIN sale_table s USING (prod_id)
WHERE s.prod_id IS NULL;
PB
Grant Giddens wrote:
Hi,
I have 2 tables like:
product_table:
prod_id
item_name
price
data
data
etc
sale_table:
prod_id
sale_price
If I want to select all the products that are in the product_table, but not in
the sale_table, how to make the query? The product_table has all the products,
but the sale table is a subset of the product_table.
I tried:
SELECT item_name FROM product_table, sale_table WHERE product_table.prod_id !=
sale_table.prod_id but I'm not getting any results from that.
Sorry this code isn't exact, I'm not att my development PC at the moment.
Thanks,
Grant
---------------------------------
Brings words and photos together (easily) with
PhotoMail - it's free and works with Yahoo! Mail.
---------------------------------
No virus found in this incoming message. Checked by AVG Free Edition. Version:
7.1.375 / Virus Database: 267.15.6/257 - Release Date: 2/10/2006
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.375 / Virus Database: 267.15.6/257 - Release Date: 2/10/2006
---------------------------------
What are the most popular cars? Find out at Yahoo! Autos
