Re: How to select data if not in both tables?

[Bob Gailer]

Peter Brawley 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;
I have not tested that but I don't think it will work. Try:

SELECT item_name FROM product_table WHERE prod_id not in (select prod_id from sale_table);