create table tblName as (select a.kl,a.flag,a.acc,a.flag1,a.accbal + newB.sumJY,a.op_date from a, (select b.yzacc,sum(b.jy_famt) sumJY from b group by b.yzacc) newB where a.acc=newB.yzacc)
修正一下: create table tblName as (select a.kl,a.flag,a.acc,a.flag1,a.accbal + newB.sumJY as accbal,a.op_date from a, (select b.yzacc,sum(b.jy_famt) sumJY from b group by b.yzacc) newB where a.acc=newB.yzacc)
(select a.kl,a.flag,a.acc,a.flag1,a.accbal + newB.sumJY,a.op_date from a,
(select b.yzacc,sum(b.jy_famt) sumJY from b group by b.yzacc) newB
where a.acc=newB.yzacc)
create table tblName as
(select a.kl,a.flag,a.acc,a.flag1,a.accbal + newB.sumJY as accbal,a.op_date from a,
(select b.yzacc,sum(b.jy_famt) sumJY from b group by b.yzacc) newB
where a.acc=newB.yzacc)