05_check_nationalities.sql

   1 -- Query to check if all the nationalities are now rocognized
   2 -- If the result of this query is not empty, 04_nationalities.sql nedds to be updated
   3 SELECT DISTINCT  Code_nationalite
   4            FROM  fusionax_anciens AS f
   5           WHERE  NOT EXISTS (SELECT  *
   6                                FROM  geoloc_pays AS g
   7                               WHERE  g.license_plate = f.Code_nationalite);
   8
   9
  10 -- vim:set syntax=mysql: