Re: Another way
From: Alan <alanshein_at_erols.spambuster.com>
Date: 2000/03/20
Message-ID: <8b5c9s$75o$1_at_bob.news.rcn.net>#1/1
Date: 2000/03/20
Message-ID: <8b5c9s$75o$1_at_bob.news.rcn.net>#1/1
You should first try to figure it out on your own, otherwise, your professor should give us the grade <g>. Depending on what the way the tables are structured, it shouldn't be very hard to figure out. Why don't you give it a try, and then post what you came up with?
MICHAIL K. GKIOURTAS wrote in message
<01bf92ae$ff25dee0$9e6aa7c3_at_default>...
>We have the following relations(attached)
>
>a)How will I find the names of all juniors who are enrolled in a class
>taught by J.Hill, using SQL-92 joins?
>b)Using joins again.how will I FIND THE NAMES OF STUDENTS WHO ARE NOT
>ENROLLED IN ANY CLASS?
>Thanks.
>
>Michael 20/3/2000
Received on Mon Mar 20 2000 - 00:00:00 CET