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