RIGHT JOIN in MySQL

The RIGHT JOIN (or RIGHT OUTER JOIN) in MySQL returns all records from the right table and the matching records from the left table. If no match is found, NULL values are returned for the left table.

1. Syntax

SELECT columnsFROM left_tableRIGHT JOIN right_tableON left_table.common_column = right_table.common_column;

• left_table → The table on the left side of the JOIN clause.
• right_table → The table on the right side of the JOIN clause.
• If there’s no match, NULL values appear in the left table’s columns.

2. Example Tables

📌 Table: departments (Right Table)

📌 Table: employees (Left Table)

3. RIGHT JOIN Example

SELECT employees.emp_id, employees.name, departments.dept_nameFROM employeesRIGHT JOIN departments ON employees.dept_id = departments.dept_id;

✅ Result:

Explanation:

• Alice and Bob have matching department IDs.
• Finance department has no matching employee, so NULL appears in emp_id and name.

4. Difference Between RIGHT JOIN and LEFT JOIN

💡 Example of LEFT JOIN (Opposite of RIGHT JOIN):

SELECT employees.emp_id, employees.name, departments.dept_nameFROM employeesLEFT JOIN departments ON employees.dept_id = departments.dept_id;

5. RIGHT JOIN with WHERE Clause

To filter results:

SELECT employees.emp_id, employees.name, departments.dept_nameFROM employeesRIGHT JOIN departments ON employees.dept_id = departments.dept_idWHERE departments.dept_name = 'Finance';

✅ Result:

Key Takeaways

✅ RIGHT JOIN returns all rows from the right table and matches from the left table.
✅ If no match is found, NULL values appear in the left table columns.
✅ Use WHERE to filter results.
✅ Opposite of LEFT JOIN.