update T
set
T.columnOne = S.columnOne,
T.columnTwo = S.columnTwo
from target as T inner join source as S
on T.columnZero = S.columnZero , etc ...