Re: Another way

Thomas Muller wrote in message ...
<snip>
>> Student(snum , sname, major,level,age)
>> Class(cname, meets_at, room,fid)
>> Enrolled(snum, cname)
>> Faculty(fid, fname)

<snip>

>No joins needed here:
>
>SELECT s.snum, s.sname
>FROM Student
>WHERE s.snum NOT IN (SELECT snum FROM Enrolled)
>
>--
>
>Thomas
>
>
This may be faster for the second query.

SELECT s.snum, s.sname
FROM Student
WHERE NOT EXISTS (SELECT * FROM Enrolled where Student.snum=Enrolled.snum)

Jason Webster Received on Thu Mar 23 2000 - 00:00:00 CET