SQL Update Statement

[skhanal]

Are you using SQL Server?

You can use

update t set c1=t1.c1, c2 = t2.c2
from t1, t2, t
where ....