有两个表,一个明细A,一个总表AAA的结构min num num1 name 10.0 5 3 N1 AA的结构name num num1 N1我的要求是将a表中N1所订的所有数量num和num1,汇总后加入到AA表 N1的num和num1中,要如何实现,请各位指点
是不是可以用这样的 update AA set num=(select sum(A.num) from A where A.name='N1') where name='N1',num1=(select sum(A.num) from A where A.name='N1') where name='N1'
update AA set num=T.num,num1=T.num1 from (select name,sum(num) as num,sum(num1) as num1 from A group by name) T,AA where T.name=AA.name and T.name='N1'
10.0 5 3 N1
AA的结构name num num1
N1我的要求是将a表中N1所订的所有数量num和num1,汇总后加入到AA表 N1的num和num1中,要如何实现,请各位指点
update AA set num=(select sum(A.num) from A where A.name='N1') where name='N1',num1=(select sum(A.num) from A where A.name='N1') where name='N1'
(select name,sum(num) as num,sum(num1) as num1
from A
group by name) T,AA
where T.name=AA.name and T.name='N1'