3 lines
193 B
SQL
3 lines
193 B
SQL
SELECT codNaf5 AS codNaf, libNaf5 AS libNaf FROM jo.tabNaf5 WHERE LENGTH(codNaf5)=5
|
|
UNION
|
|
SELECT codNaf700 AS codNaf, libNaf700 AS libNaf FROM jo.tabNaf4 WHERE libNaf700!='' ORDER BY codNaf; |