Oracle # 分组查询数据无数据时不显示0

最近在写一个视图，数据表中无数据的时候竟然不显示数据了，怎么可以让无数据的时候显示0呢？

原语句：

select 
D_DATEMONTH as month,
count(1) as sum,decode('YC','YC','测试')as type
from(
SELECT AAIP.YCDIMISSION.P_PERSONNELNO,AAIP.YCDIMISSION.P_NNAME,AAIP.YCDIMISSION.D_DATEMONTH
FROM AAIP.YCDIMISSION 
) where  D_DATEMONTH=to_char(sysdate,'yyyy-MM') 
GROUP BY D_DATEMONTH

现语句：

select t1.month, count(D_DATEMONTH) as sum,decode('YC','YC','测试')as type
from 
(select  to_char(sysdate, 'YYYY-MM' )as month  from dual )t1 left join YCDIMISSION t2
on t1.month=t2.D_DATEMONTH
group by t1.month

 

 成功解决了我的问题。