Soit Merge, soit


Update (
Select t1.col oldval, t2.col newval
From t1
Join
t2
On t1.cle = t2.cle
) t