Set [ChampA] = 'MaValeur' WHERE [MaTableA].[ClePrimaire] In (Select [ClePrimaire] FROM [MaTableB])