Re: how to write this query ( sorry typo in previous one)
From: Jim Kennedy <kennedy-family_at_attbi.com>
Date: Wed, 09 Oct 2002 01:16:56 GMT
Message-ID: <csLo9.16642$YR.33964_at_rwcrnsc51.ops.asp.att.net>
Date: Wed, 09 Oct 2002 01:16:56 GMT
Message-ID: <csLo9.16642$YR.33964_at_rwcrnsc51.ops.asp.att.net>
What is the teacher's email address?
Jim
"Kumar" <kumar_kmk_at_hotmail.com> 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 Wed Oct 09 2002 - 03:16:56 CEST