select sum(jcss) as 总数 sum(jcje) as 总金额 groupby yplb
解决方案 »
- idhttp 多线程 下载 报 存储空间不足 无法完成此操作
- 由谁用ReportMachine做过报表吗?帮帮我。谢谢了。
- 请问下面语句为什么不能起作用呢?谢谢。
- 各位大家有没有用ADO替换BDE的方法?
- 这段程序老有问题那位高人能告诉我是怎么回事?(100分)up有分
- 请问怎么用leftStr?急!
- 高分求助!500
- 怎样获得Windows的System文件夹的路径?
- 已经打开mdi子窗体[窗体A]为最大化,为何再打开另一个mdi子窗体[窗体B](不是最大化)时,窗体a会变成窗体b的大小?
- 哪儿有错!!!??????
- 在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