Quick and best way to Compare Two Tables in SQL - DWgeek.com

PHOTO EMBED

Fri Jul 23 2021 21:12:14 GMT+0000 (Coordinated Universal Time)

Saved by @mvieira

Select * from ( 
Select Id_pk, col1, col2...,coln from table1, ‘Old_table’ 
Union all 
Select Id_pk, col1, col2...,coln from table2, 'New_tbale' 
) cmpr order by Id_pk;
content_copyCOPY

https://dwgeek.com/quick-best-way-compare-two-tables-sql.html/