merge into t_inventory t
using (select t.materialcode ,sum (r.c_number) as c_number ,sum(r.pernet) as total from t_inventory t ,t_inventorydetails r where t.id = r.inventoryid group by t.materialcode ) tt
on(t.materialcode =tt. materialcode)
when matched then
update set t.c_number = tt.c_number , t.total = tt.total
using (select t.materialcode ,sum (r.c_number) as c_number ,sum(r.pernet) as total from t_inventory t ,t_inventorydetails r where t.id = r.inventoryid group by t.materialcode ) tt
on(t.materialcode =tt. materialcode)
when matched then
update set t.c_number = tt.c_number , t.total = tt.total
扫一扫
456
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
