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

This should also work:

SQL> SELECT st_id, name 
   >   FROM student
   >  WHERE st_id NOT IN (SELECT st_id 
                            FROM course
                           WHERE subj_id IN ('23','24'))

Hope this helps ...

kumar_kmk_at_hotmail.com (Kumar) wrote in message news:<bce41b15.0210081657.46328aed_at_posting.google.com>...
> 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 Thu Oct 10 2002 - 22:11:12 CEST