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

Home -> Community -> Usenet -> c.d.o.misc -> SQL QUERY QUESTION...

SQL QUERY QUESTION...

From: <jk_man_at_my-deja.com>
Date: Wed, 01 Dec 1999 19:04:47 GMT
Message-ID: <823rgd$pd0$1@nnrp1.deja.com>


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

Original text of this message

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