LEFT JOIN, RIGHT JOIN Operations Example

This example assumes the existence of hypothetical Department Name and Department ID fields in an Employees table. Note that these fields do not actually exist in the Northwind database Employees table. It selects all departments, including those without employees.

SELECT [Department Name], FirstName & Chr(32) & LastName AS Name 
FROM Departments LEFT JOIN Employees ON 
Departments.[Department ID] = Employees.[Department ID] 
ORDER BY [Department Name];