[platal.git] / upgrade / merge-0.0.1 / 05_check_nationalities.sql

-- Query to check if all the nationalities are now rocognized
-- If the result of this query is not empty, 04_nationalities.sql nedds to be updated
SELECT DISTINCT  Code_nationalite
           FROM  fusionax_anciens AS f
          WHERE  NOT EXISTS (SELECT  *
                               FROM  geoloc_pays AS g
                              WHERE  g.license_plate = f.Code_nationalite);


-- vim:set syntax=mysql:
Commit	Line	Data
b8ed94e9 SJ	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: