Home / SQL / Reference / Joins

SQL INNER JOIN

Combine rows of two tables that match on a condition.

Syntax

SELECT …
FROM a
JOIN b ON b.key = a.key;

Only pairs that match are kept. JOIN on its own means INNER JOIN.

Example

Query (on the shop database used in the SQL course)

SELECT o.order_id, o.order_date, c.name
FROM orders AS o
JOIN customers AS c ON c.customer_id = o.customer_id
LIMIT 5;

Result

order_idorder_datename
12025-06-10Aarav Sharma
22025-05-17Aarav Sharma
32025-03-25Aarav Sharma
42025-10-26Aarav Sharma
52025-02-27Aarav Sharma

5 rows

Related

Learn it step by step in the free lesson Joining Tables, with exercises that check your queries.