update archives set js=（select sum（js）from archiveInwhere id=aa.id）where id in （select id from archive aa）
------解决思路----------------------
我傻了，居然把表 archiveIn看成表 archiveInwhere
UPDATE T1
SET js=T2.js
FROM archives T1
JOIN(SELECT id,SUM(js)js FROM archiveIn GROUP BY id)T2
ON T1.id=T2.id