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