GeoNames Home | Postal Codes | Download / Webservice | About 

GeoNames Forum
  [Search] Search   [Recent Topics] Recent Topics   [Groups] Back to home page 
[Register] Register /  [Login] Login 
Canadian and Australian divisions  XML
Forum Index -> Administrative Divisions
Author Message
[Post New]11/06/2013 06:28:08
    Subject: Canadian and Australian divisions
[Up]
magabo



Joined: 10/06/2013 19:25:31
Messages: 1
Offline
I'm trying to find the way to make a join between allCountries table and postal codes table for Canada and Australia.

I'm joining by allCountries.name and postal_codes.place_name but I also need to join by state name, id or code.

In allCountries the value for admin_code1 is numeric for example '05' and on postal codes table it has letters for example 'WA'

Any help?
Thank you
 
Forum Index -> Administrative Divisions
Go to:   
Powered by JForum 2.1.5 © JForum Team