Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT products.* FROM products WHERE product_id IN (
- SELECT product_id FROM products
- MINUS
- SELECT DISTINCT product_id FROM
- (SELECT product_id, order_id FROM products CROSS JOIN orders
- MINUS
- SELECT product_id, order_id FROM product_on_order)
- );
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement