SqlServer 多表数据按日期汇总

大体流程：

1，使用sqlserver  Convert将日期转换为yyyy/mm/dd的格式；

2，使用fulljoin 按条件合并多张表;

3，使用isnull()处理表和表合并;

下面是sql

 两张表

 select  ISNULL(a.name,b.name) as name, num1 from newuser a 
full join userproductnum b on a.name=b.name where 1=1

多张表多条件:

select  ISNULL(a.name,b.name) as name, a.num1, num2 from newuser a full join 
           (select  ISNULL(c.name,d.name) as name,c.num2 from userproductnum1 c full join userproductnum2 d on c.name=d.name where 1=1 )
            as b on a.name=b.name where 1=1

 按日期汇总多表:

select  ISNULL(a.name,b.name) as name, a.num1, num2 from newuser a full join 
           (select  ISNULL(c.name,d.name) as name,c.num2 from 
           (select COUNT(*) as num1,CONVERT(varchar,CreateDate,111) as  CreateDate from userproductnum1 where 1=1 group by  CreateDate ) c 
           full join