[RESOLVED] Proper Join

[Shawazi]

Hey,
If I have the table products and the table order_products, what join do I use to select all products NOT listed in order_products?

[devinemke]

you did not say anything about how these two tables relate to each other (primary key / foreign key) but i will assume that the PK for products is called product_id and there is a column of the same name in order_products as a FK. if your database supports subqueries then do:

SELECT * FROM products WHERE product_id NOT IN(SELECT DISTINCT product_id FROM order_products)

[Shawazi]

Thanks, I wasn't aware of NOT IN. It works. 🙂