its is specific to sqlserver:
update t1
set t1.c1=t2.c1,
t2.c2=t2.c2
from table1 t1
inner join table2 t2
on t1.col=t2.col
~Technical Analyst~
Type: Posts; User: psingla; Keyword(s):
its is specific to sqlserver:
update t1
set t1.c1=t2.c1,
t2.c2=t2.c2
from table1 t1
inner join table2 t2
on t1.col=t2.col
~Technical Analyst~