1 2 3 4 5 6 7 8
SELECT * FROM course FULL OUTER JOIN party ON course.attendant = party.attendant WHERE course.attendant IS NULL OR party.attendant IS NULL