Difference between revisions of "SQL Queries and examples"
From MyWiki
(Created page with "Using in line queries for "exists" <source lang="sql"> SELECT * FROM customers WHERE EXISTS (SELECT * FROM orders WHERE customers.customer_id = orders.customer_id);...") |
|||
Line 1: | Line 1: | ||
− | Using in line queries for "exists" | + | [[ Using in line queries for "exists" ]] |
<source lang="sql"> | <source lang="sql"> | ||
SELECT * | SELECT * |
Revision as of 08:30, 4 August 2021
Using in line queries for "exists"
SELECT * FROM customers WHERE EXISTS (SELECT * FROM orders WHERE customers.customer_id = orders.customer_id);