Using in line queries for "exists"

From MyWiki
Jump to: navigation, search
SELECT *
FROM customers
WHERE EXISTS 
  (SELECT *
   FROM orders
   WHERE customers.customer_id = orders.customer_id);