UPDATE 
      dbo.Table2   
SET
      dbo.Table2.ColB = dbo.Table2.ColB + dbo.Table1.ColB  


FROM 
      dbo.Table2   

INNER JOIN 
      dbo.Table1   

ON
      Table2.ColA = Table1.ColA