SQL - LEFT and RIGHT JOIN
What will this query output?
SELECT Departments.name, Employees.name FROM Departments RIGHT OUTER JOIN Employees ON Departments.id = Employees.dept_id;
What will this query output? SELECT Departments.name, Employees.name FROM Departments RIGHT OUTER JOIN Employees ON Departments.id = Employees.dept_id;
medium📝 query result Q5 of 15
Step-by-Step Solution
Solution:
Step 1: Understand RIGHT OUTER JOIN
RIGHT OUTER JOIN keeps all rows from Employees (right table) and matches Departments; unmatched Departments show NULL.Step 2: Interpret output columns
Employees.name always present; Departments.name NULL if no matching department.Final Answer:
All employees with their department names; NULL if no department -> Option BQuick Check:
RIGHT OUTER JOIN keeps all right rows with NULLs for unmatched left [OK]
Quick Trick: Right outer join keeps all right table rows [OK]
Common Mistakes:
MISTAKES- Mixing up left and right tables
- Expecting only matched rows
- Assuming NULLs are replaced with defaults
Master "LEFT and RIGHT JOIN" in SQL
Want More Practice?
15+ quiz questions · All difficulty levels · Free
Free Signup - Practice All QuestionsMore SQL Quizzes