Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> SQL Question
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
![]() |
![]() |