查人人中国名人网黄金棒和refa选哪一个:关于 UNION的SQL语句,高手帮忙
来源：百度文库 编辑：查人人中国名人网 时间：2024/05/02 17:04:38
Set rs = New Recordset '关键过程
With rs
.CursorLocation = adUseClient
.CursorType = adOpenStatic
.Open "(select c.name as 名称, a.mc as 金额 from 表1 as a,表2 as c where a.code=c.code group by c.name )" & _
" union (select c.name as 科目名称, d.mb as 金额 from 表3 as d,code as c where d.ccode=c.ccode group by c.name ) ", conn
End With
筛选出来的记录是:
名称 金额
北京 100
北京 300
上海 400
问:如何再将 记录"合计"? 再用一个 group by??????????
With rs
.CursorLocation = adUseClient
.CursorType = adOpenStatic
.Open "(select c.name as 名称, a.mc as 金额 from 表1 as a,表2 as c where a.code=c.code group by c.name )" & _
" union (select c.name as 科目名称, d.mb as 金额 from 表3 as d,code as c where d.ccode=c.ccode group by c.name ) ", conn
End With
筛选出来的记录是:
名称 金额
北京 100
北京 300
上海 400
问:如何再将 记录"合计"? 再用一个 group by??????????
"(select 名称, sum(金额) as 合计 from ((select c.name as 名称, a.mc as 金额 from 表1 as a,表2 as c where a.code=c.code group by c.name )" & _
" union (select c.name as 科目名称, d.mb as 金额 from 表3 as d,code as c where d.ccode=c.ccode group by c.name )) group by 名称) "
二楼的是不是语句查询也是空的？