sql-server - 连接两个表中的数据

Question

在我的项目中，公司的客户正在打电话询问他们的设备。每次调用电话时，都会将其保存在数据库中。现在我需要知道公司在特定年份的每个月接到了多少电话，所以我写了这个请求:

SELECT COUNT(EveLngId) FROM T_Evenement
where EveLngDosId = 1062
And EveLngBibId = 268
And EveTinSite = 1
And EveLngEleId <> 17432
And (EveTinParEmail is null OR EveTinParEmail = 0)
And (EveLngTicketTransfertId IS NULL OR EveLngTicketTransfertId = 0)
And (EveTinIncidentAnnulation is null or EveTinIncidentAnnulation=0)
And YEAR(EveDatRedaction) = 2013
group by MONTH(EveDatRedaction)

请求有效，但问题是当一个月的值为 null 时，我不会显示 Null 或 0 但它会跳过它。为了管理它，我创建了一个日历表，如下所示:

所以现在我需要加入这两个表以获得每个月的值，但我可以弄清楚如何做到这一点。任何建议或解决方案？

Answer 1

;WITH ResultsCTE AS
(
    SELECT MONTH(EveDatRedaction) AS ResultMonth,
           COUNT(EveLngId) AS ResultCount 
    FROM   T_Evenement
    where  EveLngDosId = 1062
           And EveLngBibId = 268
           And EveTinSite = 1
           And EveLngEleId <> 17432
           And (EveTinParEmail is null OR EveTinParEmail = 0)
           And (EveLngTicketTransfertId IS NULL OR EveLngTicketTransfertId = 0)
           And (EveTinIncidentAnnulation is null or EveTinIncidentAnnulation=0)
           And YEAR(EveDatRedaction) = 2013
    GROUP BY MONTH(EveDatRedaction)
)
SELECT CalendarStrLibelle,ISNULL(ResultCount,0) AS ResultCount
FROM   Calendar 
       LEFT JOIN ResultsCTE 
          ON ResultMonth = CalendarLngId