两个查询结果相加

[zwh6735]

查询结果一：
select QY,CS,avg(convert(float,[N1])) AS N1 from sc_zj_zhcx where QY=QY and CS =CS
and convert(float,[N1])!=0 group by QY,CS

查询结果二：
select QY,CS, avg(convert(float,[N2])) AS N2 from sc_zj_zhcx where QY=QY and CS =CS
and convert(float,[N2])!=0 group by QY,CS

怎么得到结果 QY,CS,N1,N2

[百年树人]

try

select QY,CS,
avg(case when convert(float,[N1])!=0 then convert(float,[N1])!= end) AS N1,
avg(case when convert(float,[N2])!=0 then convert(float,[N2])!= end) AS N2
from sc_zj_zhcx 
where QY=QY and CS =CS  
group by QY,CS