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: |