34,593
社区成员
发帖
与我相关
我的任务
分享
update a
set a.numroll_now=a.numroll_now-b.num_roll,a.weight_now=a.weight_now-b.weight_sinlib
from wm_invfil a inner join
(select a.materialid as materialid,c.id_quote_info,sum(c.num_roll)as num_roll,sum(c.weight_sinlib)as weight_sinlib from sm_salord_info a
inner join sm_delnot_info b on a.id=b.id_salord_info
inner join wm_sinlib_info c on b.id=c.id_quote_info group by a.materialid,c.id_quote_info)b on a.code=b.materialid
update a
set a.no_2=a.no_2-b.no
from
tab_1 a
inner join
(select id_tab_1,sum([no]) as [no] from inserted group by id_tab_1) b
on a.id=b.id_tab_1