how to write this query ( sorry typo in previous one)

I have these tables

student( st_id,name)
subject (subj_id,name)
course (st_id,subj_id) 1 student can takemutiple subjects.

I want a query to find all students who did not take any of subj_id's say 23,24

So if
student1 takes subjects 21,22,45
student2 takes 1,12,23,67,75
student3 takes 14,23,24,27
student4 takes 1,2,3,4

The query should return me studentid's 1 and 4 only

Thanks
Kumar Received on Wed Oct 09 2002 - 02:57:04 CEST