Summary - INNER JOIN

Write an internal report with self JOIN and chained JOINs.

INNER JOIN combines two tables on a shared column and keeps only matching rows. ON defines the match.

SELECT o.id, c.name
FROM orders o
INNER JOIN customers c ON o.customer_id = c.id;

Summary join query.

o.id, c.name is selected from orders o. customers c is joined on o.customer_id = c.id, keeping only matching rows.

Exercise Summary - INNER JOIN

Summary: join orders with customers using INNER JOIN.

Show example solution

SELECT o.id, c.name
FROM orders o
INNER JOIN customers c ON o.customer_id = c.id;

Next lesson: LEFT JOIN