update 主表 set 主表.pzje=(select sum(子表.je) from 子表,主表 where 子表.pzh=主表.pzh and jdbz="借" group by 子表.jdbz)
update gl_pzml set pzje = t.借方金额 from gl_pzml, (select kjqj,pzh,sum(借方金额) as 借方金额 from gl_pznr group by kjqj,pzh) t where gl_pzml.kjqj = t.kjqj ,gl_pzml.pzh = t.pzh
select sum(子表.je) from 子表 group by 子表.jdbz
update 主表 set pzje=(select sum(子表.je) from 子表 where 子表.kjqj=主表.kjqj and 子表.pzh=主表.pzh and 子表.jdbz='借')
请表: 主表字段:kjqj pzh pzje
2001 记账25 ?
子表字段:kjqj pzh je jdbz
2001 记账25 100 借
2001 记账25 200 借
2001 记账25 300 贷
我要得到?=子表中前两条记录,jdbz=借的和即300
set pzje = t.借方金额
from gl_pzml,
(select kjqj,pzh,sum(借方金额) as 借方金额 from gl_pznr group by kjqj,pzh) t
where gl_pzml.kjqj = t.kjqj ,gl_pzml.pzh = t.pzh
set pzje=(select sum(子表.je) from 子表 where 子表.kjqj=主表.kjqj and 子表.pzh=主表.pzh and 子表.jdbz='借')