create view aa as select id , title , puttime from table1 union all select id , title1 title , puttime1 puttime from table2 select * from aa order by puttime
select * from ( select id ,title,puttime from A union all select id ,title1,puttime1 from B ) tmp order by puttime
select * from (select * from table 2 insert into table1)as tablename order by puttime
as
select id , title , puttime from table1
union all
select id , title1 title , puttime1 puttime from table2
select * from aa order by puttime
select id ,title,puttime from A
union all
select id ,title1,puttime1 from B
) tmp order by puttime
就是一个锲套查询的问题