Difference between revisions of "SQL Queries and examples"

From MyWiki
Jump to: navigation, search
 
(2 intermediate revisions by the same user not shown)
Line 1: Line 1:
[[ Using in line queries for "exists" ]]
+
[[ Using in line queries for "exists" ]]<br>
<source lang="sql">
+
[[ Create a simple test table ]]
SELECT *
+
FROM customers
+
WHERE EXISTS
+
  (SELECT *
+
  FROM orders
+
  WHERE customers.customer_id = orders.customer_id);
+
 
+
</source>
+

Latest revision as of 08:31, 4 August 2021

Using in line queries for "exists"
Create a simple test table