|
楼主 |
发表于 2021-3-2 15:39
|
显示全部楼层
[广告] Excel易用宝 - 提升Excel的操作效率 · Excel / WPS表格插件 ★ 免费下载 ★ ★ 使用帮助★
非常非常非常的感谢提供的思路,我在你的基础上把[查询a]这个表也放进去做union all了,你目前的代码会漏掉我[查询a]这个表的数据,因为[查询a]是我的主查询。
- sql = ""
- sql = sql & "select 客户编码"
- sql = sql & ",MAX(客户名称) AS 客户名称"
- sql = sql & ",SUM([余额]) AS [余额]"
- sql = sql & ",SUM([任务1月]) AS [任务1月]"
- sql = sql & ",SUM([任务2月]) AS [任务2月]"
- sql = sql & ",SUM([销量1月]) AS [销量1月]"
- sql = sql & ",SUM([销量2月]) AS [销量2月]"
- sql = sql & " from ("
- sql = sql & "select 客户编码,NULL AS 客户名称"
- sql = sql & ",IIF(月份=1,任务,0) AS [任务1月]"
- sql = sql & ",IIF(月份=2,任务,0) AS [任务2月]"
- sql = sql & ",0 AS [销量1月]"
- sql = sql & ",0 AS [销量2月]"
- sql = sql & ",0 AS [余额]"
- sql = sql & " from [任务d$]"
- sql = sql & " UNION ALL "
- sql = sql & "select 客户编码,NULL AS 客户名称"
- sql = sql & ",0 AS [任务1月]"
- sql = sql & ",0 AS [任务2月]"
- sql = sql & ",IIF(月份=1,销量,0) AS [销量1月]"
- sql = sql & ",IIF(月份=2,销量,0) AS [销量2月]"
- sql = sql & ",0 AS [余额]"
- sql = sql & " from [销量e$]"
- sql = sql & " UNION ALL "
- sql = sql & "select 客户编码,NULL AS 客户名称"
- sql = sql & ",0 AS [任务1月]"
- sql = sql & ",0 AS [任务2月]"
- sql = sql & ",0 AS [销量1月]"
- sql = sql & ",0 AS [销量2月]"
- sql = sql & ",[余额]"
- sql = sql & " from [余额c$]"
- sql = sql & " UNION ALL "
- sql = sql & "select 客户编码,客户名称"
- sql = sql & ",0 AS [任务1月]"
- sql = sql & ",0 AS [任务2月]"
- sql = sql & ",0 AS [销量1月]"
- sql = sql & ",0 AS [销量2月]"
- sql = sql & ",0 AS [余额]"
- sql = sql & " from [名称b$]"
- sql = sql & " UNION ALL "
- sql = sql & "select 客户编码"
- sql = sql & ",0 AS [客户名称]"
- sql = sql & ",0 AS [任务1月]"
- sql = sql & ",0 AS [任务2月]"
- sql = sql & ",0 AS [销量1月]"
- sql = sql & ",0 AS [销量2月]"
- sql = sql & ",0 AS [余额]"
- sql = sql & " FROM [查询a$a2:a5000]"
- sql = sql & ") "
- sql = sql & " GROUP BY 客户编码 "
复制代码 |
|