[Solved] Identify the issue in this SQL join:SELECT E.EmployeeName, D.Name FROM Employees E JOIN Departments D ON E.DeptID = D.... | SQL

SQL - INNER JOIN

Identify the issue in this SQL join:

SELECT E.EmployeeName, D.Name FROM Employees E JOIN Departments D ON E.DeptID = D.DepartmentID;

Given DeptID is a foreign key in Employees and DepartmentID is the primary key in Departments.

AThere is no issue; the join is correct

BThe join condition uses mismatched columns

CThe alias names are incorrect

DThe join type should be LEFT JOIN instead of JOIN

Step-by-Step Solution

Solution:

Quick Trick: Foreign key must match primary key in JOIN [OK]

Common Mistakes:

MISTAKES

Master "INNER JOIN" in SQL

9 interactive learning modes - each teaches the same concept differently

More SQL Quizzes

Identify the issue in this SQL join: