注册 登录
编程论坛 SQL Server论坛

请教SQL语句错在哪里???

foshan 发布于 2008-02-20 14:34, 1189 次点击
1、执行以下查询语句时出现“在关键字 'Union' 附近有语法错误。”,不知如何更正错误???
2、以下查询语句为了实现在最后一行统计  FuKuanJinE 字段之和,请问能否精简一下代码??
谢谢大家!

select
HeTongXinXi.HeTongID,HeTongBianHao,HeTongMingCheng,YiFangDanWei,convert(varchar(10),FuKuanShiJian,120) as FuKuanShiJian,FuKuanJinE
from HeTongXinXi
right join ShiGongHeTongFuKuanDengJi on HeTongXinXi.HeTongID=ShiGongHeTongFuKuanDengJi.HeTong_ID
where  XiangMuMingChenID  like '%1/2/3/11%' order by HeTongBianHao
Union all
select
null as HeTongID,总计 as HeTongBianHao,null as HeTongMingCheng,null as YiFangDanWei,null as FuKuanShiJian,sum(FuKuanJinE) as FuKuanJinE
from HeTongXinXi
right join ShiGongHeTongFuKuanDengJi on HeTongXinXi.HeTongID=ShiGongHeTongFuKuanDengJi.HeTong_ID
where  XiangMuMingChenID  like '%1/2/3/11%'
4 回复
#2
XieLi2008-02-21 13:22
不能用ORDER BY
#3
foshan2008-02-28 08:57
谢谢!将 ORDER BY 放在最后就可以解决出错的问题了。
select
HeTongXinXi.HeTongID,HeTongBianHao,HeTongMingCheng,YiFangDanWei,convert(varchar(10),FuKuanShiJian,120) as FuKuanShiJian,FuKuanJinE
from HeTongXinXi
right join ShiGongHeTongFuKuanDengJi on HeTongXinXi.HeTongID=ShiGongHeTongFuKuanDengJi.HeTong_ID
where  XiangMuMingChenID  like '%1/2/3/11%'
Union all
select
null as HeTongID,总计 as HeTongBianHao,null as HeTongMingCheng,null as YiFangDanWei,null as FuKuanShiJian,sum(FuKuanJinE) as FuKuanJinE
from HeTongXinXi
right join ShiGongHeTongFuKuanDengJi on HeTongXinXi.HeTongID=ShiGongHeTongFuKuanDengJi.HeTong_ID
where  XiangMuMingChenID  like '%1/2/3/11%'
order by HeTongBianHao
#4
foshan2008-02-28 08:59
还有一个问题:上述语句有很多重复部分,如何将上述的语句精简一下啊?
#5
恋轩念伊人2008-03-02 22:26
看的脑袋晕乎乎的
1