Sqlserver Update 用法

update Table_1 set id2=(select SUM(id2) from Table_2 where Table_1.id1=Table_2.id1)