Dear concern,
I have two tables table 1 = id, name, city
table 2 = id, name, city
I already combined all data of table 1 and table 2 and put them in table 3 (id,name,city) using UNION ALL
insert into table3
select
from
( select from dbo.table1
union all
select * from dbo.table2)t
now on regular base my table 1 and table 2 data update
so how I can put only the updated data from table 1 and table 2 to table 3
your help is really appreciable
thanks