SQL SERVEL 合并表之间列

这个小问题，搞了好几次，记录一下

SQL SERVEL 合并表之间列：如下所示

合并前：

    select a.DisplayTime    
    ,count(c.InsertDate) as AppointCount
    from TempDataNodeTime a    
    left join TableAppointmentMainInfo c on substring(convert(char(7) ,c.InsertDate, 21),1,7)=a.DisplayTime
    group by a.[DisplayTime] 
    
    select 
    a.DisplayTime
    ,
    count(b.createdate) as ApplyCount    
    from TempDataNodeTime a
    left join HISAPPLICATIONFORM b on substring(convert(char(7) ,b.createdate, 21),1,7)=a.DisplayTime    
    group by a.[DisplayTime]

 

 

合并后：

select aa.DisplayTime,aa.AppointCount,bb.ApplyCount from 
    (
    select a.DisplayTime    
    ,count(c.InsertDate) as AppointCount
    from TempDataNodeTime a    
    left join TableAppointmentMainInfo c on substring(convert(char(7) ,c.InsertDate, 21),1,7)=a.DisplayTime
    group by a.[DisplayTime] 
    ) as aa,
    (
    select 
    a.DisplayTime
    ,
    count(b.createdate) as ApplyCount    
    from TempDataNodeTime a
    left join HISAPPLICATIONFORM b on substring(convert(char(7) ,b.createdate, 21),1,7)=a.DisplayTime    
    group by a.[DisplayTime]
    ) as bb
    where aa.DisplayTime =bb.DisplayTime