Cheat Sheet logoCheat Sheet Today
SQL Cheat Sheet/Right join

Keep all rows from the right table.

Back to sheetBrowse commands
Sign in to save
Section: Joins

Right join

sql
sql
SELECT e.employee_id, d.department_name
FROM employees e
RIGHT JOIN departments d ON d.department_id = e.department_id;
Explanation

Many teams prefer rewriting RIGHT JOIN as LEFT JOIN for consistency.

View in sheet →

Learn the surrounding workflow

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

Compare commandsView fixes

Related commands

Same sheet · prioritizing Joins
Inner join two tables
Return rows with matches in both tables.
OpenIn sheetsqlsame section
Left join
Keep all rows from the left table and match rows from the right table.
OpenIn sheetsqlsame section
Full outer join
Return matched and unmatched rows from both tables.
OpenIn sheetsqlsame section
Self join
Join a table to itself.
OpenIn sheetsqlsame section
Cross join
Return the Cartesian product of two sets.
OpenIn sheetsqlsame section
Select all columns
Return all columns from a table.
OpenIn sheetsql