Update T set col=S.col from TargetTable T inner join SourceTable S on T.keycol= S.keycol. Otherwise post some sample data and the result you ...
www.sqlteam.com