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 *
7 WHERE g.license_plate
= f.Code_nationalite
);
10 -- vim:set syntax=mysql: