Use NomBaseSQL Update [dbo].[NomTable01] Set [NomTable01].[ChampA] = [NomTable02].[ChampA] FROM [NomTable01] Inner Join [NomTable02] On [NomTable01].[ChampB] = [NomTable02].[ChampB]