una cosa tipo questa, usando left join
codice:
SELECT EMPLOYEE.*, DEPENDENT.* FROM EMPLOYEE LEFT JOIN DEPENDENT ON EMPLOYEE.SSN = DEPENDENT.ESSN