RIGHT JOIN

sql

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

Explanation

Many teams prefer rewriting this as a `LEFT JOIN` by swapping table order for readability.

Learn the surrounding workflow

Compare similar commands or jump into common fixes when this command is part of a bigger troubleshooting path.

Same sheet · prioritizing Join types at a glance

Return only rows that match on both sides.

Open In sheetsqlsame section

Keep all rows from the left table and match rows from the right when available.

Open In sheetsqlsame section

Keep all rows from both tables and match where possible.

Open In sheetsqlsame section

Produce the Cartesian product of two tables.

Open In sheetsqlsame section

Prefer primary keys and foreign keys over names or free-form text.

A `WHERE` clause can accidentally turn a left join into an inner join.