MySQL如何将两次查询的结果合并？

[Philippian]

select zy as 专业,count(*)as 男
from XSB 
where xb=1 
group by zy

select zy as 专业,count(*)as 女 
from XSB
where xb=0
group by zy

结果是这样：


想把女生的第二列，加到男生的右边。形成3*3的结果。

[Ekun_sky]

select zy as 专业,count(*)as 男
from XSB 
where xb=1 
group by zy
union all
select zy as 专业,count(*)as 女 
from XSB
where xb=0
group by zy

[Ekun_sky]

select zy as 专业,sum(case xb when 1 then 1 else 0 end) as 男, sum(case xb when 0 then 1 else 0 end) as 女
group by zy

[卖水果的net]

改成 2 # 的写法比较好， sum(case xb when 1 then 1 else 0 end) 可以改成 sum(if(xb=1),1,0)