What's new in Customer Journeys?

Connect and learn more! ×
Getting same geography code for different city under same state and county — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Getting same geography code for different city under same state and county

Received Response
34
Views
1
Comments

Summary:

Getting same geography code for different city under same state and county, i am expecting unique city code for all cities under same county and state. i am using below query, please let me know if my understanding is correct or any issue with the code?

Content (required):


Version (include the version you are using, if applicable):


Code Snippet (add any code snippets that support your topic, if applicable):

SELECT st_name.identifier_value CITY,

state_ident.identifier_value CODE

          FROM hz_geographies state_geo

               ,hz_geography_identifiers state_ident

               ,hz_geography_identifiers st_name 

           WHERE state_geo.geography_type = 'CITY' 

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!