将同一表的同一字段进行相加
update AAA T1
set (T1.Age, T1.score) =
(select t2.age+t3.age, t2.score+t3.score from AAA T2
inner join AAA T3 on t2.IDNUM = t3.IDNUM
where T1.IDNUM = T2.IDNUM
)