- SELECT a2, a3, n3, worldrgn, pays, country, capital, nat, phoneprf, phoneformat, license_plate
- FROM geoloc_pays;
+ SELECT g.a2, g.a3,
+ CASE g.a2 WHEN "MG" THEN 450
+ WHEN "MK" THEN 807
+ WHEN "ER" THEN 232
+ ELSE n3 END,
+ worldrgn, pays, country, capital, nat,
+ phoneprf, phoneformat, t.code
+ FROM #x4dat#.geoloc_pays AS g
+ INNER JOIN tmp_update_geoloc_pays AS t ON (t.a2 = g.a2);