Difference between revisions of "SQL Queries and examples"

From MyWiki
Jump to: navigation, search
(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);