update table1 set a = table2.a from table2 where b = table2.b---- orupdate table1 set a = table2.a from (select ........from ...) as table2 where b = table2.b
1. insert into targettable (field1,field2,...) select * from sourcetable 2.update a set a.field1=b.field1,a.field2=b.field2 from b where a.fieldx=b.fieldx
set a = table2.a
from
table2
where b = table2.b---- orupdate table1
set a = table2.a
from
(select ........from ...) as table2
where b = table2.b
2.update a set a.field1=b.field1,a.field2=b.field2 from b where a.fieldx=b.fieldx