在执行下面的语句时出现下面的错误:试图执行的操作中不包含作为合计函数的一部分‘rq’,求高人帮忙
cnn.Execute "insert into fpb1(rq,fph,c1,pm,gg,hbh,c1hbh,rkxs,sl) select fpb.rq,fpb.fph,fpb.c1,fpb.pm,fpb.gg,fpb.hbh,fpb.c1hbh,fpb.rkxs,sum(sl) as sl from fpb group by c1hbh"
...全文
1289打赏收藏
一个sql语句
在执行下面的语句时出现下面的错误:试图执行的操作中不包含作为合计函数的一部分‘rq’,求高人帮忙 cnn.Execute "insert into fpb1(rq,fph,c1,pm,gg,hbh,c1hbh,rkxs,sl) select fpb.rq,fpb.fph,fpb.c1,fpb.pm,fpb.gg,fpb.hbh,fpb.c1hbh,fpb.rkxs,sum(sl) as sl from fpb group by c1hbh"
可是我这一句就没什么问题,两个是一前一后
cnn.Execute "insert into xjb(c1,pm,gg,hbh,n4,nxcl,wxcl,sl,je) select rkxs.c1,rkxs.pm,rkxs.gg,rkxs.hbh,sum(n4) as n4,sum(nxcl) as nxcl,sum(wxcl) as wxcl,sum(sl) as sl,sum(je) as je from rkxs group by c1,pm,gg,hbh"
因为你有sum 是聚合函数
所以 fpb.rq,fpb.fph,fpb.c1,fpb.pm,fpb.gg,fpb.hbh,fpb.c1hbh,fpb.rkxs 这些都要在group by 中
正确的sql为
insert into fpb1(rq,fph,c1,pm,gg,hbh,c1hbh,rkxs,sl) select fpb.rq,fpb.fph,fpb.c1,fpb.pm,fpb.gg,fpb.hbh,fpb.c1hbh,fpb.rkxs,sum(sl) as sl from fpb group by c1hbh,fpb.rq,fpb.fph,fpb.c1,fpb.pm,fpb.gg,fpb.hbh,fpb.c1hbh,fpb.rkxs
insert into fpb1(rq,fph,c1,pm,gg,hbh,c1hbh,rkxs,sl) select fpb.rq,fpb.fph,fpb.c1,fpb.pm,fpb.gg,fpb.hbh,fpb.c1hbh,fpb.rkxs,sum(sl) as sl from fpb group by c1hbh,fpb.rq,fpb.fph,fpb.c1,fpb.pm,fpb.gg,fpb.hbh,fpb.c1hbh,fpb.rkxs