Joining Three or More Tables | Learn SQL Visual

Add Joins One Stage at a Time

JOIN can continue across three or more tables. Join customers to orders, then order_items, to place an order, its customer, and its items in one result. An order with several items appears once for each item.

If order 1 has two items, how many rows represent order 1 in the three-table result?

CHECK IT

FROM orders o
JOIN customers c ON o.customer_id = c.id

orders AS o4 rows

id	customer_id
1	1
2	1
3	2
4	3

customers AS c4 rows

id	name
1	Alice
2	Bob
3	Carol
4	Dave

First compare orders.customer_id with customers.id to pair each order with a customer.