SQL Question

From: Uzmati29 <uzmati29_at_aol.com>
Date: 15 Mar 2000 01:43:01 GMT
Message-ID: <20000314204301.02594.00002006@ng-fq1.aol.com>

Hi,

I am a college student taking a class in database design and I have been having some trouble with a query that my instructor assigned. I am using SQL + 3.3 with oracle.

The Query is:

What pilots are certified to fly all the types of aircraft that John Baum is certified to fly?

Here is the basic table structure:

Employee(E_ID, SSN, LName, FName, MI, Address, DOH, Salary, Base, Category, Year_of_Birth)

Pilot_Attrib( E_ID, Can_Fly)

I have been unable to figure out how to work this query. I think that I might have to join the Pilot_Attrib table with itself, but I cannot figure out how to eliminate those pilots that are certified with some but not all of the same planes as John Baum.

thanks Received on Tue Mar 14 2000 - 19:43:01 CST