SQL · Joins and set operations

inner join

Keeps only rows with a match on both sides.

sqlRunnable example sql course

Syntax

from a join b on a.id = b.a_id

Example

Open in the lab

WITH courses(id, title) AS (VALUES (1, 'HTML'), (2, 'CSS')),
     lessons(course_id, title) AS (VALUES (1, 'Intro'), (1, 'Forms'))
SELECT c.title, l.title AS lesson
FROM courses c JOIN lessons l ON l.course_id = c.id;

Learn this in the course

Reference pages are the quick answer. The course explains the why, shows the full example and ends with a challenge.

Open the course

inner join

Example

More in this group

Learn this in the course