SQL join on value?

I am trying to match es.51.h with this: LEFT JOIN admin2codes ON admin2codes.adm2code = 'geoname.countrycode . geoname.countrycode . geoname.admin2code but ain’t working please help?

I don’t know how to add a point in between the values?

10 posts were merged into an existing topic: Join to primary table?