Update [dbo].[TableA] Set [TableA].[ChampA] = [TableB].[ChampA] FROM [TableA] Inner Join [TableB] On [TableA].[sAMAccountName] = [TableB].[sAMAccountName]