Lesson 9 of 22 · SQLite

INNER JOIN

Learn SQL INNER JOIN: combine rows from two tables where they match.

An INNER JOIN returns only rows where there is a match in both tables.

Syntax

SELECT a.col1, b.col2
FROM table_a a
INNER JOIN table_b b ON a.id = b.a_id;

List each person's name next to the make of car they drive. Leave out people without a licence.

Free, no sign-up. The SQLite database runs in your browser; your answer is checked instantly, with hints if you need them. Plus a 1-question quiz.