Full Outer Join (SQL)

Full Outer Join (FULL OUTER JOIN): Keeps values from the both tables even if they are not matched.

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

This will match employees without supervisors and employees not supervising anyone.