Greetings.

I started out trying to do this in Crystal Reports 2k8 but couldnt quite accomplish what I was looking for.  And the only way I could think to do this in sql was the following:

select s.pupil_number from students s
where s.grade = '09'
and s.school = 60
and s.withdraw_date is null
minus
select s.pupil_number from students s, course_selections cs, courses c
where s.pupil_number = cs.pupil_number
and cs.course_id = c.id
and c.course_code = '0223'
and s.grade = '09'
and s.school = 60
and c.year = 2010
and s.withdraw_date is null;

The goal is just to find out which kids are not taking the course 0223.

Have you tried: