I have tried adding SubjectCategory to the SELECT and/or GROUP BY clauses but don't get any better results. Thanks again for any help or ideas. SELECT a.meetingID, a.timeSlot FROM crossref_room_subject a , Subjects b WHERE a.subjectID = b.subjectID AND ( b.subjectCategory ...