Member Avatar for rickya100

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!

Picture_1.png 25.83 KB
  • 2 Contributors
  • 1 Reply
  • 126 Views
  • 21 Hours Discussion Span
  • Latest Post Latest Post by baki100
Member Avatar for baki100

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

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.