Re: how to write this query ( sorry typo in previous one)
Date: Wed, 9 Oct 2002 09:31:33 -0700
Message-ID: <ao1lij$c74$1_at_spiney.sierra.com>
heh, heh, heh...
"Jim Kennedy" <kennedy-family_at_attbi.com> wrote in message
news: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 - 18:31:33 CEST