LEFT JOIN, RIGHT JOIN Operations Examples
SQL statement | Description |
SELECT [Department Name], | Selects all departments, including those without employees |
SELECT [Last Name] & ", " & [First Name] | Selects all employees, including those not assigned to a department |