prova:

codice:
update T1, T2
set T2.C3 = T1.C3, T2.C4 = T1.C4
where T1.C1 = T2.C1
AND T1.C2 = T2.C2