select * from t1 union all select * from t2 order by 日期
select * from t1,t2 order by t1.日期,t2.日期
两个表中有不同数目的字段,這樣就應該以字段少的表為主,兩個表才能合併起來,因為用 union all連接的表,兩個的這字段結構要一樣才能成功。select field1,field2,field3,date1 from (select field1,field2,field3,date1 from t1 union all select field1,field2,field3,date1 from t2) as t3 order by date1
如果你想讓字段多的那個表都顯示出來,那字段少的表所少的字段補上,也就是說要補上和字段多的表的字段數目一樣多,才能實現兩個表合並,並且結構完全一樣。字段少的表可以補上,但補上的字段要設為空值null。 如t1表的字段少field3,則 select field1,field2,field3,date1 from (select field1,field2,field3=null,date1 from t1 union all select field1,field2,field3,date1 from t2) as t3 order by date1總之兩個的結構要完全一樣才能合並。
select * from t1
union all
select * from t2 order by 日期
from (select field1,field2,field3,date1 from t1
union all select field1,field2,field3,date1 from t2) as t3
order by date1
如t1表的字段少field3,則
select field1,field2,field3,date1
from (select field1,field2,field3=null,date1 from t1
union all select field1,field2,field3,date1 from t2) as t3
order by date1總之兩個的結構要完全一樣才能合並。