同一workbook内多个worksheet用sq查询得到的值可不可以用sql一次性相加

袁振涛

例如营销费表格里的，我可以用  select 税后金额 from [营销费$]
例如职工教育经费表格里的，我可以用  select 税后金额 from [职工教育经费$]
例如工资表格里的，我可以用  select 金额 from [工资$]
那么问题来了这三个可不可以用sql一次性汇总到一起

opiona

1. select 税后金额 ,0 AS 金额 from [营销费$]
   
2. UNION ALL select 税后金额,0 AS 金额 from [职工教育经费$]
   
3. UNION ALL select 0 AS 税后金额,金额 from [工资$]

复制代码

或者：

1. select 税后金额  from [营销费$]
   
2. UNION ALL select 税后金额 from [职工教育经费$]
   
3. UNION ALL select 金额 AS 税后金额, from [工资$]

复制代码

袁振涛

opiona 发表于 2018-4-24 14:33
或者：

1. select sum(预算) as 金额 from [办证费用$] union all select sum(工资总额) as 金额 from [开业前工资$] union all select sum(税后金额) as 金额 from [开业前福利费$] union all select sum(公司承担保险) as 金额 from [开业前工资$] union all select sum(公司承担公积金) as 金额 from [开业前工资$] union all select sum(独生子女费) as 金额 from [开业前工资$] union all select sum(税后金额) as 金额 from [开业前差旅费$] union all select sum(税后金额) as 金额  from [开业营销费$] union all select sum(税后金额) as 金额 from [开业前职工教育经费$]

复制代码

这个为什么不对，返回值只是select sum(预算) as 金额 from [办证费用$]的金额