Advertisement
klinki

SQL dotaz s cenou 500k

Mar 28th, 2012
67
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. SELECT products.* FROM products WHERE product_id IN (
  2. SELECT product_id FROM products
  3.   MINUS
  4. SELECT DISTINCT product_id FROM
  5. (SELECT product_id, order_id FROM products CROSS JOIN orders
  6.   MINUS
  7. SELECT product_id, order_id FROM product_on_order)
  8. );
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement