SQL問題：如何才能不用UNION,實作兩個表的垂直合并？0
lcic4356y2013.07.04浏覽130次分享舉報
要求，不使用union，來将表一表二合并成表三：
表一
id name time
------- --------------- -----------------------
1 name1 2010-07-22 11:01:02.903
2 name2 2010-07-22 11:01:02.903
3 name3 2010-07-22 11:01:02.903
表二
id name time
------- --------------- -----------------------
1 t2_name1 2010-07-22 11:01:02.903
2 t2_name2 2010-07-22 11:01:02.903
3 t2_name3 2010-07-22 11:01:02.903
1 t3_name1 2010-07-22 11:01:02.920
2 t3_name2 2010-07-22 11:01:02.920
3 t3_name3 2010-07-22 11:01:02.920
表三
id name time
------- --------------- -----------------------
1 name1 2010-07-22 11:01:02.903
2 name2 2010-07-22 11:01:02.903
3 name3 2010-07-22 11:01:02.903
1 t2_name1 2010-07-22 11:01:02.903
2 t2_name2 2010-07-22 11:01:02.903
3 t2_name3 2010-07-22 11:01:02.903
1 t3_name1 2010-07-22 11:01:02.920
2 t3_name2 2010-07-22 11:01:02.920
3 t3_name3 2010-07-22 11:01:02.920