select goods.id,goods.number as [number],goods.name as name,sum(detailcheck.number) as xssl,sum(detailcheck.price*detailcheck.number) as zqje,sum(detailcheck.je) as xsje,sum(detailcheck.ml) as ml,sum(detailcheck.je)-sum(detailcheck.ml) as xscb from ((((maincheck left outer join detailcheck on ( maincheck.id=detailcheck.checkid)) left outer join customer on (maincheck.customerid=customer.id)) left outer join store on (maincheck.jhstoreid=store.id or maincheck.chstoreid=store.id)) left outer join employee on (maincheck.agentid=employee.id)) left outer join goods on (detailcheck.goodsid=goods.id) where ifcheck='true' and ifrollback='false' and maincheck.rq<=#2005-10-16# and maincheck.djtype='零售单' or maincheck.djtype='销售退货单' or maincheck.djtype='借转销售单' or maincheck.djtype='批发单' group by goods.number,goods.name,goods.id order by xsje desc错误提示:至少一个参数没有被指定值
就是最后排序用的xsje这个参数。
去掉 order by xsje desc 就没问题了。
就是最后排序用的xsje这个参数。
去掉 order by xsje desc 就没问题了。
解决方案 »
- activereport报表,在一台机器上打出乱码(方块),如何办?
- 买东西啊.~ 刘海接旨
- 怎么在程序中引入ADSI接口?
- 俺有的是分,就等一个好答案了 (50+50)
- 请问有哪位大侠用过WNetAddConnection这个东东?
- 有关数据库连接的问题????
- 请问。怎么可以把系统的时间。用自已的一个TEXT或是LABEL控件来显示。
- 怎么样通过写注册表来添加一种文件类型并设置高级属性
- 不会没人愿意回答这个问题吧,都贴第二次了!!
- 关于COM+中JIT激活的疑问
- VB操作ACCESS一问,代码如下
- 请教高手:能不能用Hock技术对datagrid控件进行二次开发?如果可能,请赐些示例代码!谢谢!
请注意xsje是一个sum和,而不是单独的字段
sum(detailcheck.je) as xsje 得到的只是一个值,不是字段,用order by xsje desc 就会出错。
order by xsje desc 改
ORDER BY sum(detailcheck.je) desc