RIGHT JOIN

Keep all rows from the right table.

RIGHT JOIN keeps every row from the right table. Unmatched left columns arrive as NULL.

SELECT c.name, o.id
FROM orders o
RIGHT JOIN customers c ON o.customer_id = c.id;

This query customers without orders also appear.

c.name, o.id is selected from orders o. customers c is joined on o.customer_id = c.id, keeping every row of the right table.

RIGHT JOIN — details

RIGHT JOIN is the mirror of LEFT JOIN. Swapping table order and using LEFT JOIN gives the same result.

For example, orders RIGHT JOIN customers and customers LEFT JOIN orders produce the same rows; only the order of writing differs.

Join orders with customers using RIGHT JOIN.

Show example solution

SELECT c.name, o.id
FROM orders o
RIGHT JOIN customers c ON o.customer_id = c.id;

Add RIGHT JOIN

SELECT c.name, o.id
FROM orders o
____ customers c ON o.customer_id = c.id;

Show answer

SELECT c.name, o.id
FROM orders o
RIGHT JOIN customers c ON o.customer_id = c.id;