SQL-complete-tutorial

1
-- Compound join conditions (use with composite primary keys)
2
SELECT *
3
FROM order_items oi
4
JOIN order_item_notes oin
5
	ON oi.order_id = oin.order_Id
6
	AND oi.product_id = oin.product_id;
7
    
8
-- Regular inner join code
9
SELECT *
10
FROM orders o
11
JOIN customers c
12
	ON o.customer_id = c.customer_id;
13
    
14
-- Implicit join syntax
15
SELECT *
16
FROM orders o, customers c
17
WHERE o.customer_id = c.customer_id;