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?
![[Search]](/gforum/templates/default/images/icon_mini_search.gif){kind=icon}
![[Recent Topics]](/gforum/templates/default/images/icon_mini_recentTopics.gif){kind=icon}
![[Groups]](/gforum/templates/default/images/icon_mini_groups.gif){kind=icon}
![[Register]](/gforum/templates/default/images/icon_mini_register.gif){kind=icon}
Register![[Login]](/gforum/templates/default/images/icon_mini_login.gif){kind=icon}
Login
![[Post New]](/gforum/templates/default/images/icon_minipost_new.gif){kind=icon}
![[Up]](/gforum/templates/default/images/icon_up.gif){kind=icon}
