Multi-JOIN report

Write a report joining three tables.

Multi-join report

In this challenge you will chain three tables with INNER JOIN.

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

Three-table join.

o.id, c.name, p.name is 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.

Exercise Multi-join report

Join orders, customers and products with INNER JOIN; select ids and names.

Show example solution

SELECT o.id, c.name, p.name
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

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

Two — Two JOINs need two ON clauses.
Multi-JOIN report: match the terms

INNER JOIN

intersection
ON

condition
three tables

chain
alias

alias

Next lesson: Aggregate analysis

We Are Enhancing Your Experience

Cookie Preferences

Strictly Necessary Cookies

Analytical Cookies