select a.*,b.数量2
from(select year(时间) as 时间,sum(数量) as 数量1 from 表1 group by year(时间))a
left join
(select year(时间) as 时间,sum(数量) as 数量2 from 表2 group by year(时间))b
on a.时间=b.时间
from(select year(时间) as 时间,sum(数量) as 数量1 from 表1 group by year(时间))a
left join
(select year(时间) as 时间,sum(数量) as 数量2 from 表2 group by year(时间))b
on a.时间=b.时间
from(select year(时间) as 时间,sum(数量) as 数量1 from 表1 group by year(时间))a
join
(select year(时间) as 时间,sum(数量) as 数量2 from 表2 group by year(时间))b
on a.时间=b.时间
where year(a.时间)=year(b.时间)
group by year(时间)
group by year
select isnull(a.时间,b.时间) ,sum(a.数量),sum(b.数量) from
表1 a full join 表2 b on year(a.时间)=year(b.时间)
group by isnull(a.时间,b.时间)