SQL如何将两条查询语句查询出的结果放一起

SELECT FYLX_MC,sum(JE) as YJNJE FROM WEB_GG_CBXX GROUP BY FYLX_MC;SELECT FYLX_MC,sum(JE) as WJNJE FROM WEB_GG_CBXX WHERE JFZT_BM = 'jfzt02' GROUP BY FYLX_MC;这是两条语句,如图怎么连接在一起

第1个回答  2017-01-03
union all本回答被提问者采纳
相似回答
大家正在搜