(SELECT t1.* FROM t1 LEFT JOIN t2 ON t1.codice = t2.codice WHERE t2.codice IS NULL)
UNION (SELECT * FROM t2) ORDER BY codice