ah, pensavo fossi un mago di Excel
fatti allora ispirare da questo
lo puoi testare qui https://www.db-fiddle.com/f/rbQvMuyGtpE7qV7rH1oZDY/2codice:SELECT T1.*, T2.* FROM (SELECT 't1' as src, cli, concat(nome,cognome) as name FROM Table1) AS T1 LEFT JOIN (SELECT 't2' as src, cli, concat(nome,cognome) as name FROM Table2) AS T2 ON T1.cli=T2.cli AND T1.name=T2.name WHERE T2.src IS NULL ; SELECT T2.*, T1.* FROM (SELECT 't2' as src, cli, concat(nome,cognome) as name FROM Table2) AS T2 LEFT JOIN (SELECT 't1' as src, cli, concat(nome,cognome) as name FROM Table1) AS T1 ON T2.cli=T1.cli AND T2.name=T1.name WHERE T1.src IS NULL


Rispondi quotando