Consider the following tables, what query retrieves all employees along with their department names, even if some employees are not assigned to any department?
Employees: (EmployeeID, Name, DepartmentID)
Departments: (DepartmentID, DepartmentName)

Question

Consider the following tables, what query retrieves all employees along with their department names, even if some employees are not assigned to any department?

Employees: (EmployeeID, Name, DepartmentID)
Departments: (DepartmentID, DepartmentName)

Accepted Answer

SELECT * FROM Employees LEFT JOIN Departments ON Employees.DepartmentID = Departments.DepartmentID;

Answer

SELECT * FROM Employees FULL JOIN Departments ON Employees.DepartmentID = Departments.DepartmentID;

Answer

SELECT * FROM Employees RIGHT JOIN Departments ON Employees.DepartmentID = Departments.DepartmentID;

Answer

ELECT * FROM Employees INNER JOIN Departments ON Employees.DepartmentID = Departments.DepartmentID;

Crowdly

Consider the following tables, what query retrieves all employees along with the...

Want instant access to all verified answers on eclass.yorku.ca?