两个表合成查询？？？

Question

表1：
CREATE TABLE cancel_NUM (
  id int(11) NOT NULL auto_increment,
  cancelNUM int(8) default NULL,
  savetime char(20) default NULL,
  PRIMARY KEY  (id)
) TYPE=MyISAM;
INSERT INTO cancel_NUM VALUES (16,2035,'2007-01-08');
INSERT INTO cancel_NUM VALUES (17,2048,'2007-01-09');
INSERT INTO cancel_NUM VALUES (18,2200,'2007-01-10');
INSERT INTO cancel_NUM VALUES (19,1965,'2007-01-11');
INSERT INTO cancel_NUM VALUES (20,1992,'2007-01-12');
INSERT INTO cancel_NUM VALUES (21,2,'2007-01-13');
INSERT INTO cancel_NUM VALUES (22,1,'2007-01-14');
INSERT INTO cancel_NUM VALUES (23,3,'2007-01-15');
INSERT INTO cancel_NUM VALUES (24,41,'2007-01-16');
INSERT INTO cancel_NUM VALUES (25,8105,'2007-01-17');
------------------------表1数据
+----+---------+------------+
| id | sureNUM | savetime   |
+----+---------+------------+
| 24 |       8 | 2007-01-08 |
| 25 |       3 | 2007-01-09 |
| 26 |      66 | 2007-01-10 |
| 27 |      17 | 2007-01-11 |
| 28 |      60 | 2007-01-12 |
| 29 |       1 | 2007-01-14 |
| 30 |     441 | 2007-01-15 |
| 31 |     543 | 2007-01-16 |
+----+---------+------------+表2：
CREATE TABLE sure_NUM (
  id int(11) NOT NULL auto_increment,
  sureNUM int(8) default NULL,
  savetime char(20) default NULL,
  PRIMARY KEY  (id)
) TYPE=MyISAM;
INSERT INTO sure_NUM VALUES (24,8,'2007-01-08');
INSERT INTO sure_NUM VALUES (25,3,'2007-01-09');
INSERT INTO sure_NUM VALUES (26,66,'2007-01-10');
INSERT INTO sure_NUM VALUES (27,17,'2007-01-11');
INSERT INTO sure_NUM VALUES (28,60,'2007-01-12');
INSERT INTO sure_NUM VALUES (29,1,'2007-01-14');
INSERT INTO sure_NUM VALUES (30,441,'2007-01-15');
INSERT INTO sure_NUM VALUES (31,543,'2007-01-16');
----------------------表2数据
+----+-----------+------------+
| id | cancelNUM | savetime   |
+----+-----------+------------+
| 16 |      2035 | 2007-01-08 |
| 17 |      2048 | 2007-01-09 |
| 18 |      2200 | 2007-01-10 |
| 19 |      1965 | 2007-01-11 |
| 20 |      1992 | 2007-01-12 |
| 21 |         2 | 2007-01-13 |
| 22 |         1 | 2007-01-14 |
| 23 |         3 | 2007-01-15 |
| 24 |        41 | 2007-01-16 |
| 25 |      8105 | 2007-01-17 |
+----+-----------+------------+
合成：
sureNUM  cancelNUM   savetime
....         .....    ..... 
要没有冗余

Answer 1

合成：
+-----------+------------+---------+
| cancelNUM | savetime   | sureNUM |
+-----------+------------+---------+
|      2035 | 2007-01-08 |       8 |
|      2048 | 2007-01-09 |       3 |
|      2200 | 2007-01-10 |      66 |
|      1965 | 2007-01-11 |      17 |
|      1992 | 2007-01-12 |      60 |
|         2 | 2007-01-13 |       1 |
|         1 | 2007-01-14 |     441 |
|         3 | 2007-01-15 |     543 |
|        41 | 2007-01-16 |         |
|      8105 | 2007-01-17 |         |
+-----------+------------+---------+

Answer 2

+-----------+------------+---------+
| cancelNUM | savetime   | sureNUM |
+-----------+------------+---------+
|      2035 | 2007-01-08 |       8 |
|      2048 | 2007-01-09 |       3 |
|      2200 | 2007-01-10 |      66 |
|      1965 | 2007-01-11 |      17 |
|      1992 | 2007-01-12 |      60 |
|         2 | 2007-01-13 |       1 |
|         1 | 2007-01-14 |     441 |
|         3 | 2007-01-15 |     543 |
|        41 | 2007-01-16 |         |
|      8105 | 2007-01-17 |         |
+-----------+------------+---------+

Answer 3

+-----------+------------+---------+
| cancelNUM | savetime   | sureNUM |
+-----------+------------+---------+
|      2035 | 2007-01-08 |       8 |
|      2048 | 2007-01-09 |       3 |
|      2200 | 2007-01-10 |      66 |
|      1965 | 2007-01-11 |      17 |
|      1992 | 2007-01-12 |      60 |
|         2 | 2007-01-13 |       1 |
|         1 | 2007-01-14 |     441 |
|         3 | 2007-01-15 |     543 |
|        41 | 2007-01-16 |         | 
|      8105 | 2007-01-17 |         |
+-----------+------------+---------+