<?xml version="1.0" encoding="UTF-8"?>
<rss version="2.0">
	<channel>
		<title><![CDATA[Latest posts for the topic "Canadian and Australian divisions"]]></title>
		<link>http://forum.geonames.org/gforum/posts/list/9.page</link>
		<description><![CDATA[Latest messages posted in the topic "Canadian and Australian divisions"]]></description>
		<generator>JForum - http://www.jforum.net</generator>
			<item>
				<title>Canadian and Australian divisions</title>
				<description><![CDATA[ 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]]></description>
				<guid isPermaLink="true">http://forum.geonames.org/gforum/posts/list/4282.page#12493</guid>
				<link>http://forum.geonames.org/gforum/posts/list/4282.page#12493</link>
				<pubDate><![CDATA[Tue, 11 Jun 2013 06:28:08]]> GMT</pubDate>
				<author><![CDATA[ magabo]]></author>
			</item>
	</channel>
</rss>