select m.销售部门,m.销售名字,k.计算日期,m.月收入贡献指标*10000 as 月收入贡献指标,m.特殊加减项,m.销售工资,m.佣金加减项,m.考核系数,m.折标后存续规模,sum(k.销量)as 销量,sum(k.一次性收入贡献)as 一次性收入,sum(k.一次性代算净收入贡献)as 一次性代算净收入, sum(k.分阶段收入贡献)as 分阶段收入,sum(k.分阶段代算净收入贡献)as 分阶段代算净收入, sum(k.一次性认购费)as 一次性认购费,sum(k.分阶段认购费)as 分阶段认购费from (select a.ddfwjlbmeng as 部门,a.ddfwjl as 订单服务经理,case when a.dkjedw=1 then a.dkje*a.hl/10000 else a.dkje*a.hl end as 销量,a.srgx as 一次性收入贡献,a.dssrgx as 一次性代算净收入贡献,a.rgf as 一次性认购费,left(a.jsrq,7) as 计算日期from uf_ddgl a where a.jsfs = '1' and a.ddzt in ('2','3') and a.ddssgs not in('17','5')and left(a.jsrq,7)>='${ksrq}' and left(a.jsrq,7)<='${jsrq}' union allselect a.ddfwjlbmeng as 部门,a.ddfwjl as 订单服务经理,case when a.dkjedw=1 then b.cxje*b.hl/10000 else b.cxje*b.hl end as 销量,b.srgx as 分阶段收入贡献,b.dssrgx as 分阶段代算净收入贡献,b.rgf as 分阶段认购费,left(b.jxrq,7) as 计算日期from uf_ddgl a left join uf_ddgl_dt1 b on b.mainid=a.id where a.jsfs = '0' and a.ddzt in ('2','3') and a.ddssgs not in('17','5')and left(b.jxrq,7)>='${ksrq}' and left(b.jxrq,7)<='${jsrq}' ) k right join (select xsname as 销售名字,ygzb as 月收入贡献指标,tsxm as 特殊加减项,xsgz as 销售工资,yjxm as 佣金加减项,kkxs as 考核系数,zbgm as 折标后存续规模,xsbm as 销售部门from uf_xsyjzb where left(ksdate,7)='${ksrq}' and left(jsdate,7)='${jsrq}')M on m.销售名字=k.订单服务经理group by m.销售部门,m.销售名字,k.计算日期,m.月收入贡献指标,m.特殊加减项,m.销售工资,m.佣金加减项,m.考核系数,m.折标后存续规模以上的SQL语句，提交后一直报错“正常:错误代码:1301 数据集配置错误 Query: 列名 '分阶段收入贡献' 无效。”请帮忙查看一下
