Three-table INNER JOIN

Chain JOINs across three tables.

Three-table INNER JOIN

Multiple INNER JOINs chain together. Each JOIN connects the next table with its own ON condition.

SELECT * FROM orders o
INNER JOIN customers c ON o.customer_id = c.id
INNER JOIN products p ON o.product_id = p.id;

This query joins orders, customers and products.

All columns are selected from orders o. customers c is joined on o.customer_id = c.id, keeping only matching rows. products p is joined on o.product_id = p.id, keeping only matching rows.

Three-table INNER JOIN — details

Each JOIN takes its own ON. Order affects readability, not the result.

For example, joining orders, customers and products shows the customer name and product name side by side on every order row.

Exercise Three-table INNER JOIN

Chain orders, customers and products with INNER JOIN.

Show example solution

SELECT * FROM orders o
INNER JOIN customers c ON o.customer_id = c.id
INNER JOIN products p ON o.product_id = p.id;

Test yourself

Three-table INNER JOIN: match the terms

JOIN

combine
ON

condition
AS

alias
WHERE

filter

Add the third table

SELECT * FROM orders o
INNER JOIN customers c ON o.customer_id = c.id
____ products p ON o.product_id = p.id;

Show answer

SELECT * FROM orders o
INNER JOIN customers c ON o.customer_id = c.id
INNER JOIN products p ON o.product_id = p.id;

How many ON clauses for three tables?
- Three
- Two
- One
- None
Show answer

Two — Two JOINs need two ON conditions.

Next lesson: Self JOIN

We Are Enhancing Your Experience

Cookie Preferences

Strictly Necessary Cookies

Analytical Cookies