mysql - 如何连接这两个mysql查询？

Question

我希望能够加入两种复杂的查询，但不太确定执行此操作的语法。

查询1:

select month(Date_1) as Date_1, 
       sum(number_1) as number_1 
  from table_1 
  where Date_1 between '2012-01-01' and '2013-01-01' 
  group by month(Date_1);

给出了这个结果:

查询2:

select count(distinct number_2) as number_2, 
       month(Date_2) as Date_2 
  from table_2 
  where Date_2 between '2012-01-01' and '2013-01-01' 
  group by month(Date_2) 
  order by month(Date_2) desc;

给出了这个结果:

我想加入这 2 个查询，以便当 Date_1 和 Date_2 列相等时，number_1 与 number_2 匹配。每月一行。

有人知道怎么做吗？

Answer 1

select T1.Date_1, T1.number_1, T2.number_2 from 

(select month(Date_1) as Date_1, 
       sum(number_1) as number_1 
  from table_1 
  where Date_1 between '2012-01-01' and '2013-01-01' 
  group by month(Date_1))T1

inner join

(select count(distinct number_2) as number_2, 
       month(Date_2) as Date_2 
  from table_2 
  where Date_2 between '2012-01-01' and '2013-01-01' 
  group by month(Date_2) 
  order by month(Date_2) desc)T2

on T1.Date_1 = T2.Date_2;

本质上，连接当月的两个临时表(作为查询结果形成)。