Understanding SQL RIGHT JOIN - Complete Beginner Tutorial

What is SQL RIGHT JOIN?

RIGHT JOIN is a type of outer join that returns all rows from the right table and the matched rows from the left table.

If there is no match, the result is NULL on the side of the left table.

• Includes all rows from the right table.
• Matches rows from the left table based on the join condition.
• Fills with NULLs for left table columns when no match exists.

RIGHT JOIN Syntax

The basic syntax of RIGHT JOIN is straightforward and similar to other join types.

You specify the two tables and the join condition using the ON keyword.

Example of SQL RIGHT JOIN

Let's look at a practical example using two tables: Employees and Departments.

We want to list all departments and any employees assigned to them, including departments without employees.