sql问题 - 我的帆软

sql问题

select yzcd.rs ,wzlb.rs,yzcd.selectname,wzlb.selectname

from (SELECT sum(L.nbwzrs + L.wbwzrs) as rs,L.yzcd as yzcd ,A.selectname

from uf_wzhztz L

LEFT JOIN (select * from workflow_selectitem where fieldid = 43508) A on A.SELECTVALUE =L.yzcd

where date_format(L.tbrq, '%Y-%m') = date_format(curdate(),'%Y-%m')

group by L.yzcd ) yzcd ,

(select sum(L.nbwzrs + L.wbwzrs) as rs,L.wzlb as wzlb ,A.selectname

from uf_wzhztz L

LEFT JOIN (select * from workflow_selectitem where fieldid = 43508) A on A.SELECTVALUE =L.wzlb

where date_format(L.tbrq, '%Y-%m') = date_format(curdate(),'%Y-%m')

) wzlb

目前运行结果是

看能不能把两个rs字段合并成一个rs字段，两个selectname合并成一个selectname字段

宁震天 发布于 2022-5-12 17:32

1min目标场景问卷

立即参与

回答问题关注问题

悬赏：3 F币 + 添加悬赏

提示：增加悬赏、完善问题、追问等操作，可使您的问题被置顶，并向所有关注者发送通知

共4回答

最佳回答

霜凡Lv5中级互助
发布于2022-5-12 17:38（编辑于 2022-5-12 17:41）

select yzcd.rs,yzcd.selectname from (SELECT sum(L.nbwzrs + L.wbwzrs) as rs,L.yzcd as yzcd ,A.selectname from uf_wzhztz L LEFT JOIN (select * from workflow_selectitem where fieldid = 43508) A on A.SELECTVALUE =L.yzcd where date_format(L.tbrq, '%Y-%m') = date_format(curdate(),'%Y-%m') group by L.yzcd ) yzcd union all select wzlb.rs,wzlb.selectname from (select sum(L.nbwzrs + L.wbwzrs) as rs,L.wzlb as wzlb ,A.selectname from uf_wzhztz L LEFT JOIN (select * from workflow_selectitem where fieldid = 43508) A on A.SELECTVALUE =L.wzlb where date_format(L.tbrq, '%Y-%m') = date_format(curdate(),'%Y-%m') ) wzlb