delete table A
update table A set column A=b.column A from table A a
inner join table B b on a.column C =b.column C
update table A set column B=b.column B from table A a
inner join table B b on a.column C =b.column C
update table A set column D =b.column D from table A a
inner join table B b on a.column C =b.column C
select * from dbo.table A order by column ID