SQL Server RIGHT JOIN Tutorial

Understanding RIGHT JOIN

A RIGHT JOIN returns all records from the right table and the matched records from the left table. If no match exists, the result is NULL on the left table's columns.

This join is the opposite of LEFT JOIN, which returns all rows from the left table.

• Includes all rows from the right table.
• Matches rows from the left table where possible.
• Fills with NULLs when no match is found on the left.

RIGHT JOIN Syntax

The basic syntax for RIGHT JOIN in SQL Server is:

You specify the two tables to join and the condition on which to join them.

• SELECT columns
• FROM left_table
• RIGHT JOIN right_table ON join_condition;

Example of RIGHT JOIN

Consider two tables: Employees and Departments. We want to list all departments and any employees assigned to them.

Using RIGHT JOIN ensures all departments appear, even those without employees.