Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> SQL QUERY QUESTION...
I have a table of different sports activities
(call it sports) and another table listing
different holiday resorts and the sports
facilities that they offer (call it resorts).
(You can tell that this is is a college question
!).
Now the query I have to design is...
Select only the resorts that offer _all_ the different sports facilites.
I've spent an age trying to solve this - and I just cannot figue it out.
If anyone out there has any good ideas, please let me know.
Thanx,
Jack.
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Wed Dec 01 1999 - 13:04:47 CST