Answer
A RIGHT JOIN keeps every row from the right input and matching rows from the left input. • Unmatched left-side columns become NULL. • It is logically the reversed form of a left join. • Teams often rewrite it as LEFT JOIN for consistent reading direction.
💡 SQL Example
SELECT e.name, d.name FROM employees e RIGHT JOIN departments d ON d.department_id = e.department_id;
Result
Every department, including empty departments
⚡ Quick Revision
RIGHT JOIN preserves all right-side rows.