表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,就更好了
+-------+----------+----------+
| 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,就更好了
set A.Toal=B.Total,A.date=B.date
set A.Toal=B.Total,A.date=B.date
set tmp1.total=tmp2.total,tmp1.date=tmp2.date