Difference between revisions of "Using in line queries for "exists""

From MyWiki
Jump to: navigation, search
(Created page with "<source lang="sql"> SELECT * FROM customers WHERE EXISTS (SELECT * FROM orders WHERE customers.customer_id = orders.customer_id); </source>")
 
(No difference)

Latest revision as of 08:30, 4 August 2021

SELECT *
FROM customers
WHERE EXISTS 
  (SELECT *
   FROM orders
   WHERE customers.customer_id = orders.customer_id);