摘要： 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时间来排序 阅读全文