select sum(jcss) as 总数 sum(jcje) as 总金额 groupby yplb
解决方案 »
- 问个TListView点击的问题
- 文件打包安装后,运行出现古怪提示!(毕业设计,急!!!)
- MDI 子窗体 搜索不到 ADOConnection ?
- adoquery往数据库中插入stringgrid数据???
- 那位大哥有五子棋之类的游戏源代码,给小弟传一个
- 初学者的几个问题,不明白啊,再线ing,争取今天就结贴
- 各位大哥:帮帮小弟,决不吝啬分,一定在给高分,来者有分!
- 急急问:可不可以得到组件在屏幕上的位置
- Kingron(WinAPI) 点击软件下载 显示的是一空白页面?
- 200分求购!!做一个公式解释器
- 在Delphi中如何实现将windows的任务栏设置为自动隐藏?
- vararrayof函数问题吗?
UNION ALL
SELECT SUM(jcss) AS jcss,SUM(jcje) AS jcje,yplb FROM lskh GROUP BY yplb
yplb(油品类别) lsxx.jcss(加出升数) lsxx.jcje(加出金额) lskh.jcss
(加出升数) lskh.jcje(加出金额)
我想要的结果:yplb sum(lsxx.jcss) sum(lsxx.jcje) sum(lskh.jcss) sum(lskh.jcje)
0#
90#
.
.
(select sum(jcss) as jcss,sum(jcje) as jcje,yplb from lsxx group by yplb) as x full join
(select sum(jcss) as jcss,sum(jcje) as jcje,yplb from lskh group by yplb) as y
on x.yplb=y.yplb
运行你的语句出现错误,系统提示 :'invalid column name y'
(select sum(jcss) as jcss,sum(jcje) as jcje,yplb from lsxx group by yplb) as x full join
(select sum(jcss) as jcss,sum(jcje) as jcje,yplb from lskh group by yplb) as y
on x.yplb=y.yplb