SELECT * FROM course FULL OUTER JOIN party ON course.attendant = party.attendant WHERE course.attendant IS NULL OR party.attendant IS NULL