22

来自「很不错的客房管理软件.第9次改版正式开通.每日更新.」· 代码 · 共 7 行

TRANSFORM Sum(查询1.RCount1) AS RCount1之总计
SELECT 查询1.Rtype, Sum(查询1.RCount1) AS [总计 RCount1]
FROM 查询1
GROUP BY 查询1.Rtype
PIVOT 查询1.Operation;