Cacher is the code snippet organizer for pro developers

-- seleziona i prodotti mai ordinati 
select * from tbl_products where tbl_products.Product_ID NOT IN(
select DISTINCT tbl_orders.fk_product_id
from tbl_orders)