Use ROQL to select Country Name and List of Provinces

Content

Hello, we have entered most of our country/province into Service Cloud manually, opting not to use the out of the box country names. We did this because we want our agents to be able to see the whole country name and not an abbreviation or ISO code in country drop down lists.

As a result:

Select name, id from Country LIMIT 10000

Will return: Name: Pakistan and ID: 24 - which is fine.

As soon as I edit the query to pull the "province", then I lose the country name or the province name - depending on what order I have the columns. For example: