select yzcd.rs ,wzlb.rs,yzcd.selectname,wzlb.selectname from (SELECT sum(L.nbwzrs + L.wbwzrs) as rs,L.yzcd as yzcd ,A.selectnamefrom 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.selectnamefrom uf_wzhztz LLEFT 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字段