关于union 和 order by 一起用的问题

select * from (select top 5 * from table1 order by time desc)t1
union
select * from (select top 5 * from table2 order by time desc)t2

这样就可以先按table1的时间来排序,然后再到table2时间来排序