Hi everyone,

I sat down to create a what I thought was simple SQL query but once I got thinking about it I realised I'm not sure where to start.

The objective is to return two resorts from a Resorts table for each country code in that table.

Countries table - Lists all countries
Resorts table - Lists resorts and what country code they have which links them to the Countries table.

I've included a screenshot of what data is in the Resorts table. Basically I just need the two resort names from each country code. The other data can be ignored as it's just airport codes etc.


Any ideas to help me out?

Many thanks for any help!

i think you might want to have a look at cursors, can't think of anything else at the moment though, sorry.