create table u1(id int) insert into u1 select 1 insert into u1 select 2 create table u2(id int) insert into u2 select 1 insert into u2 select 3 go select * from u1 union select * from u2 order by id desc select * from u1 union all select * from u2 order by id desc go drop table u1 drop table u2 ---------------------------- id ----------- 3 2 1 (所影响的行数为 3 行) id ----------- 3 2 1 1 (所影响的行数为 4 行)