Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.theory -> Re: Another way

Re: Another way

From: Alan <alanshein_at_erols.spambuster.com>
Date: 2000/03/20
Message-ID: <8b5c9s$75o$1@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 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US