update a set stuff = b.stuff,manpower = b.manpower,process = b.process,
produce = b.produce
from material a
join ( Select cgoodsid,sum(stuff) as stuff,sum(manpower) as manpower,sum(process) as process,sum(produce) as produce from costmemo group by cgoodsid ) b
on a.goodsid = b.cgoodsid
where idno = ?????
produce = b.produce
from material a
join ( Select cgoodsid,sum(stuff) as stuff,sum(manpower) as manpower,sum(process) as process,sum(produce) as produce from costmemo group by cgoodsid ) b
on a.goodsid = b.cgoodsid
where idno = ?????
set stuff=A.stuff,
manpower=A.manpower,
process=A.process
from (select sum(stuff) stuff,
sum(manpower) manpower,
sum(produce) produce
from FROM costmemo
WHERE goodsid=?cgoodsid ) A
where idno=?cgoodsid
material
set
stuff=b.stuff,
manpower=b.manpower,
process=b.process,
produce=b.produce
from
material a,
(select sum(stuff) as stuff,sum(manpower) as manpower,sum(process) as process,sum(produce) as produce FROM costmemo) b
produce = b.produce
from material a,( Select cgoodsid,sum(stuff) as stuff,sum(manpower) as manpower,sum(process) as process,sum(produce) as produce from costmemo group by cgoodsid ) b where a.goodsid = b.cgoodsid and idno = ?????