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

[kostion]

两张表 类型一样
table1:

hour count
1 20
2 30
3 40

table2:

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
请解答，谢谢

[ACMAIN_CHM]

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

[WWWWA]

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

[kostion]

谢谢两位，真效率

[zuoxingyu]

[Quote=引用 1 楼 acmain_chm 的回复:]
SQL code
select hour,`count` as t1_count,0 as t2_count from table1
union all
select hour,0,`count` from table2
[/Quote]

正解。