Miracle: 如果你不能确定的话,可以这样 [阅读: 562] 2005-11-01 09:00:42 select * from ( select *, 1 as TableID from A union all select *, 2 as TableID from B ) order by TableID, otherfields