SELECT * FROM PERSON LEFT OUTER JOIN INTERESTS ON (PERSON.ID = INTERESTS.PERSON_ID) LEFT OUTER JOIN OCCUPATION ON (PERSON.ID = OCCUPATION.PERSON_ID) LEFT OUTER JOIN PROGRAMMING_LANGUAGES ON (PERSON.ID = PROGRAMMING_LANGUAGES.PERSON_ID) WHERE PERSON.L_NAME = 'CANOWSKI' AND PERSON.F_NAME = 'REUBEN'