执行下边语句
select (select isnull(cast(sum(Money) as numeric(10,2)),0) from WayInfos where InfosID=Infos.ID and WayClassID=1 and WaySortID=1) as Money1,
(select isnull(cast(sum(Money) as numeric(10,2)),0) from WayInfos where InfosID=Infos.ID and WayClassID=2 and WaySortID=1) as Money2,
cast(Money as numeric(10,2)) as Money3
FROM Infos
where Infos.Name='张三' ORDER BY Infos.ID DESC
显示出 名字为“张三”的所有费用明细
Money1 Money2 Money3
2.00 2.00 4.00
1.00 0.00 1.00
3.00 2.00 5.00
1.52 2.48 4.00
这个语句怎么能再进行修改可以显示的合计数据为
Money1 Money2 Money3
2.00 2.00 4.00
1.00 0.00 1.00
3.00 2.00 5.00
1.52 2.48 4.00
合计Money1：7.52
合计Money2：6.48
合计Money3：14.00
sql 查询合计
------解决方案--------------------
Union就可以