A tricky query question...

From: <jk_man_at_my-deja.com>
Date: Wed, 01 Dec 1999 19:21:58 GMT
Message-ID: <823sgg$q9s$1@nnrp1.deja.com>

I'm doing this college assignment and I just can't solve this query - it seems straigth forward at first, but it isn't.

OK...

I'm given a table of sports activites (call this sports) and another table of holiday resorts (call this resorts) where each resort has numerous sports facilities. i.e. each resort has several rows, each one describing a different sports facility.

Now the query is:

Select all those resorts that have facilities for *all* sports activities (as listed in sports) and ignore the other resorts. I think I'm supposed to use 'MINUS', but there may be other ways also.

Anyway suggestions appreciated,
Jack.

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Dec 01 1999 - 13:21:58 CST