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.
No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.
Unsolved 
