Alice | SalesBob | NULLNULL | Marketing

Alice | SalesBob | SalesNULL | Marketing

Alice | SalesCarol | NULLNULL | Marketing

Solution:Step 1: Identify right table rowsDepartments has DeptID 10 and 30, so both rows appear.Step 2: Match Employees to DepartmentsOnly Alice has DeptID 10 matching Sales; no employee matches Marketing (30).Final Answer:Alice | SalesNULL | Marketing -> Option BQuick Check:RIGHT JOIN keeps all ri

[Solved] Given tables:Employees:ID | Name | DeptID1 | Alice | 102 | Bob | 203 | Carol | NULLDepartments:DeptID | DeptName10 | Sales30 | MarketingWhat will be the result of:SELECT Employees.Name, Departments.... | SQL

SQL - LEFT and RIGHT JOIN

SELECT Employees.Name, Departments.DeptName FROM Employees RIGHT JOIN Departments ON Employees.DeptID = Departments.DeptID;

?

AAlice | Sales Bob | NULL NULL | Marketing

BAlice | Sales NULL | Marketing

CAlice | Sales Bob | Sales NULL | Marketing

DAlice | Sales Carol | NULL NULL | Marketing

Step-by-Step Solution

Solution:

Step 1: Identify right table rows
Departments has DeptID 10 and 30, so both rows appear.
Step 2: Match Employees to Departments
Only Alice has DeptID 10 matching Sales; no employee matches Marketing (30).
Final Answer:
Alice | Sales
NULL | Marketing -> Option B
Quick Check:
RIGHT JOIN keeps all right rows, unmatched left columns NULL = Alice | Sales
NULL | Marketing [OK]

Quick Trick: RIGHT JOIN shows all right rows, unmatched left columns as NULL [OK]

Common Mistakes:

MISTAKES

Including employees with NULL DeptID
Assuming unmatched left rows appear
Mixing up which table is right

Master "LEFT and RIGHT JOIN" in SQL

9 interactive learning modes - each teaches the same concept differently

Learn Why Deep Visual Try Challenge Project Recall Time

More SQL Quizzes

Given tables:

Step 1: Identify right table rows

Step 2: Match Employees to Departments

Final Answer:

Quick Check:

Want More Practice?