select
a.pzlx,[count]=isnull(b.[count],0)
from
(select 'A' as pzlx union select 'B' union select 'C' union select 'D') a
left join
(select pzlx,count(pzlx) as count from aa group by pzlx) b
on
a.pzlx = b.pzlx
order by
a.pzlx
a.pzlx,[count]=isnull(b.[count],0)
from
(select 'A' as pzlx union select 'B' union select 'C' union select 'D') a
left join
(select pzlx,count(pzlx) as count from aa group by pzlx) b
on
a.pzlx = b.pzlx
order by
a.pzlx
union select 'B',0
(select 'A' as pzlx union select 'B' union select 'C' union select 'D') a其余的都认准了只有 B可能没有,其实很有可能是
A 0
B 0
C 0
D 1谢谢了,我会给分的!