27,579
社区成员
发帖
与我相关
我的任务
分享
update t2 set t2.prize_worth=t1.prize_worth
from 配置表 t1 ,(select prizeid,
sum(prize_worth)prize_worth
from 记录表
group by prizeid) t2
where t1.prizeid=t2.prizeid
update t2 set t2.prize_worth=t1.prize_worth
from 配置表 t1 ,记录表 t2
where t1.prizeid=t2.prizeid