How to select data if not in both tables?

[Grant Giddens]

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.