求一条SQL语句，不知道怎么写，帮看一下，里面有描述（高分）

Question

两张表   类型一样   
table1:hour        count
1            20
2            30
3            40table2:hour        count
4            25
5            35
6            45我像要的查询结果格式如下
hour        t1_count        t2_count
1             20              0
2             30              0
3             40              0
4              0             25
5              0             35
6              0             45
请解答，谢谢

Answer 1

select  hour,`count` as t1_count,0 as t2_count from table1
union all
select  hour,0,`count` from table2

Answer 2

用UNION ALL就行了
select  hour,`count` as t1_count,0 as t2_count from table1
union all
select  hour,0,`count` from table2