Left Outer Join (SQL)

Left Outer Join (LEFT OUTER JOIN): Keeps values from the left table even if they are not matched.

SELECT E.name, S.fname
FROM (
					EMPLOYEE E
	LEFT OUTER JOIN EMPLOYEE AS S
				 ON E.super_ssn=S.ssn
)

This will match employees without supervisors.