又来了，再求一条sql,语句，高分，ACMAIN_CHM，WWWWA进来帮看一下，谢谢

表1  tmp1
+-------+----------+----------+
| total | hour     |     date |
+-------+----------+----------+
|     0 |        0 | NULL     |
|     0 |        1 | NULL     |
|     0 |        2 | NULL     |
|     0 |        3 | NULL     |
|     0 |        4 | NULL     |
|     0 |        5 | NULL     |
|     0 |        6 | NULL     |
|     0 |        7 | NULL     |
|     0 |        8 | NULL     |
|     0 |        9 | NULL     |
|     0 |       10 | NULL     |
|     0 |       11 | NULL     |
|     0 |       12 | NULL     |
|     0 |       13 | NULL     |
|     0 |       14 | NULL     |
|     0 |       15 | NULL     |
|     0 |       16 | NULL     |
|     0 |       17 | NULL     |
|     0 |       18 | NULL     |
|     0 |       19 | NULL     |
|     0 |       20 | NULL     |
|     0 |       21 | NULL     |
|     0 |       22 | NULL     |
|     0 |       23 | NULL     |
+-------+----------+----------+表2 tmp2
+---------+----------+------------+
| total   |     hour |     date   |
+---------+----------+------------+
|     312 |       11 | 2010-09-29 |
|      20 |       15 | 2010-09-29 |
|      35 |       17 | 2010-09-29 |
|      68 |       20 | 2010-09-29 |
+---------+----------+------------+我像用表2来填充表1， 查询出来后应该是这样的
+-------+----------+----------+
| total | hour     |     date |
+-------+----------+----------+
|     0 |        0 | NULL     |
|     0 |        1 | NULL     |
|     0 |        2 | NULL     |
|     0 |        3 | NULL     |
|     0 |        4 | NULL     |
|     0 |        5 | NULL     |
|     0 |        6 | NULL     |
|     0 |        7 | NULL     |
|     0 |        8 | NULL     |
|     0 |        9 | NULL     |
|     0 |       10 | NULL     |
|   312 |       11 | 2010-9-29|
|     0 |       12 | NULL     |
|     0 |       13 | NULL     |
|     0 |       14 | NULL     |
|    20 |       15 | 2010-9-29|
|     0 |       16 | NULL     |
|    35 |       17 | 2010-9-29|
|     0 |       18 | NULL     |
|     0 |       19 | NULL     |
|    68 |       20 | 2010-9-29|
|     0 |       21 | NULL     |
|     0 |       22 | NULL     |
|     0 |       23 | NULL     |
+-------+----------+----------+请问怎么写sql，谢谢  ，说明 表2是一张临时表，数据是从其他表中查出来的，如果能直接从其他表中查出数据，来填充表1，就更好了