我这样写为什么也不行:
select riqi,bm,sum(gwgz) as Gwhj,sum(glbt) as glhj,Sum(yfbg) as yfbghj,Sum(jbf) as jbfhj,Sum(jj) as jjhj,Sum(Yfxj) as yfhj,Sum(Fzf) as fzhj,Sum(sdf) as sdhj,Sum(Dhf) AS dhfhj,Sum(Ghf) as ghfhj,Sum(tcjj) as tchj,Sum(sds) as sdshj,Sum(Qtyk) as qtykhj, Sum(ykxj) as ykhj,Sum(sfje) as sfhj From Temp where Riqi='''+Edit1.Text+''' 是不是我这里错了?
Group by Bm
我在SQL EXPLORER 中这样写
Select BM,gwgz,glbt,yfbg,jbf,jj,yfxj,fzf,sdf,dhf,ghf,tcjj,sds,qtyk,ykxj,sfje from temp group by bm;
提示我错误如下:
General SQL error.
[Microsoft][ODBC Microsoft Access Driver] 试图执行的查询中不包含作为合计函数一部分的特定表达式 'gwgz' 。
我去掉‘GWGZ’后又出现'Glbt'为什么?神啊救救我吧!
这是我的项目中用的一个SQL。
你的情况这样能实现:
select info.peij_no as 配件编码,
info.peij_th as 配件图号,
info.peij_mc as 配件名称,
info.peij_cx as 车型,
info.peij_jk as 进口,
info.peij_dw as 单位,
f2.peij_kc as 数量,
f2.jiag_jp as 单价,
f2.peij_je as 金额
from kucshp_info info,
(select peij_no, peij_je , peij_kc , case peij_kc when 0 then 0 else peij_je / peij_kc end jiag_jp from
(select peij_no,
sum(isnull(f.peij_kc,0)) as peij_kc,
sum(isnull(f.peij_je,0)) as peij_je
from kucshp_fl f group by peij_no ) f1 ) f2
where info.peij_no = f2.peij_no