数据插入问题（在线等，急！）

Question

我想把 a,b表检索出来的数据插入到Erp_pp_zz_scjh_a中去（有多条记录），请问一下语句哪里出错了，sql一直执行失败。
谢谢，得到答案马上给分。insert into Erp_pp_zz_scjh_a(ddbh_sap,xh_hb,khbm,khmc,cpbm,cpmc,cpmf,cpkz,yssq,sczzl,jhrq_khyq) values (:s_ddbh_sap,:s_xh_hb,:s_khbm,:s_khmc,:s_cpbm,:s_cpmc,:s_cpmf,:s_cpkz,:s_yssq,:d_mpxql,:d_jhrq_khyq) 
select ddbh_sap,xh_hb,khbm_sdf,khmc_sdf,a.cpbm,a.cpmc,a.cpmf,a.cpkz,yssq,sum((1+shl_rb)*zl) mpxql,jhrq_khyq from erp_sd_ddxxb_b b,erp_sd_ddxxb_a a where b.ddbh_np=a.ddbh_np and a.ddbh_sap=:s_ddbh_sap group by ddbh_sap,xh_hb,a.cpbm,a.cpmc,khbm_sdf,khmc_sdf,a.cpmf,a.cpkz,yssq,jhrq_khyq using sqlca;

Answer 1

insert into Erp_pp_zz_scjh_a(ddbh_sap,xh_hb,khbm,khmc,cpbm,cpmc,cpmf,cpkz,yssq,sczzl,jhrq_khyq)
select ddbh_sap,xh_hb,khbm_sdf,khmc_sdf,a.cpbm,a.cpmc,a.cpmf,a.cpkz,yssq,sum((1+shl_rb)*zl) mpxql,jhrq_khyq 
from erp_sd_ddxxb_b b,erp_sd_ddxxb_a a 
where b.ddbh_np=a.ddbh_np and a.ddbh_sap=:s_ddbh_sap 
group by dbh_sap,xh_hb,a.cpbm,a.cpmc,khbm_sdf,khmc_sdf,a.cpmf,a.cpkz,yssq,jhrq_khyq 
----using sqlca;(这个是？？？)

Answer 2

group　by后面咋那么多东西啊？

Answer 3

insert into Erp_pp_zz_scjh_a(ddbh_sap,xh_hb,khbm,khmc,cpbm,cpmc,cpmf,cpkz,yssq,sczzl,jhrq_khyq) values (:s_ddbh_sap,:s_xh_hb,:s_khbm,:s_khmc,:s_cpbm,:s_cpmc,:s_cpmf,:s_cpkz,:s_yssq,:d_mpxql,:d_jhrq_khyq) 
select ddbh_sap,xh_hb,khbm_sdf,khmc_sdf,a.cpbm,a.cpmc,a.cpmf,a.cpkz,yssq,sum((1+shl_rb)*zl) mpxql,jhrq_khyq from erp_sd_ddxxb_b b,erp_sd_ddxxb_a a where b.ddbh_np=a.ddbh_np and a.ddbh_sap=:s_ddbh_sap group by ddbh_sap,xh_hb,a.cpbm,a.cpmc,khbm_sdf,khmc_sdf,a.cpmf,a.cpkz,yssq,jhrq_khyq using sqlca;---》这是SQL server 的SQL语句吗，怎么会有:s_ddbh_sap，这个是不是字段名，要是真的是字段名就要加[]包括起来.