UNION和NOT EXISTS抛出错误

I have a table which contains city name in both English and french name only if the name are different else it will have only English name. NOTE. Geocode will be same for the city CityA and CityA` since both are the same city but code will be different.I have a table which contains city name in both