If there is A and B two tables, there is A same column name CITY, but A.C ITY in cities such as Shanghai, Beijing, zhangjiakou
Biggest ITY in cities such as Shanghai, Beijing, zhangjiajie
Now you need to link the two tables in the CITY field is obtained B table CITY_ID, how to break the head has crack

CodePudding user response:

You think that this association:
Take A, B table of the first two characters, correlation, can see,

This is the city of non-standard, place names called multifarious