SQL · Joins and set operations

right join

Keeps every right row. Prefer swapping the tables and using LEFT JOIN for readability.

sqlRunnable example sql course

Syntax

from a right join b on …

Example

Open in the lab

WITH a(id) AS (VALUES (1)), b(id) AS (VALUES (1), (2))
SELECT a.id AS a_id, b.id AS b_id FROM a RIGHT JOIN b ON a.id = b.id;

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