<?xml version="1.0" encoding="UTF-8"?>
<rss version="2.0">
	<channel>
		<title><![CDATA[Latest posts for the topic "Relation Between Geo_name and Admin1CodesAscii Tables"]]></title>
		<link>http://forum.geonames.org/gforum/posts/list/9.page</link>
		<description><![CDATA[Latest messages posted in the topic "Relation Between Geo_name and Admin1CodesAscii Tables"]]></description>
		<generator>JForum - http://www.jforum.net</generator>
			<item>
				<title>Relation Between Geo_name and Admin1CodesAscii Tables</title>
				<description><![CDATA[ Hello,

I am using the new version of the Geo Names database. I need to join the geo_names and admin1CodesAscii tables. I am not clear how to create a dependency between the two tables. I understand admin1CodesAscii.CODE=(geoName.COUNTRY_CODE + '.' + geoName.Admin1_CODE)

Has anyone got an idea as to how I can declare this relation when creating the tables so that I can use the default joins in PHP Symfony?

Thank you.]]></description>
				<guid isPermaLink="true">http://forum.geonames.org/gforum/posts/list/4091.page#12130</guid>
				<link>http://forum.geonames.org/gforum/posts/list/4091.page#12130</link>
				<pubDate><![CDATA[Wed, 9 Jan 2013 06:29:03]]> GMT</pubDate>
				<author><![CDATA[ Hope]]></author>
			</item>
	</channel>
</rss>