合并两张表时，如何对一张表内容排序

[talentmykaka]

SELECT 编号,姓名,性别 FROM T1
union all
SELECT 编号,姓名,性别 FROM T2

这样是把T1和T2表进行合并，但我想把T2表进行排序后在合并，比如
SELECT 编号,姓名,性别 FROM T1
union all
SELECT 编号,姓名,性别 FROM T2 ORDER BY 编号
这样就会报错，如何才能达到这样的效果

[gogodiy]

先将T2表排序后输入临时表：
SELECT 编号，姓名，性别 INTO #T2 FROM T2 ORDER BY 编号
然后用临时表去合并：
SELECT 编号，姓名，性别 FROM T1
UNION ALL
SELECT 编号，姓名，性别 FROM #T2

[Stone19840824]

合并之后再重新排序呢

[iamltd]

SELECT 编号,姓名,性别 FROM T1
union all
select * from (
SELECT 编号,姓名,性别 FROM T2 ORDER BY 编号
)a

[billpu]

SELECT 编号,姓名,性别 FROM T1
union all  
select * from (
SELECT top 1000000000 编号,姓名,性别 FROM T2 ORDER BY 编号
)a

[dawugui]

SELECT 编号,姓名,性别 FROM T1
union all
SELECT 编号,姓名,性别 FROM T2
ORDER BY t1.编号


select * from
(
SELECT 编号,姓名,性别 FROM T1
union all
SELECT 编号,姓名,性别 FROM T2
) t
ORDER BY 编号

[talentmykaka]

[Quote=引用 5 楼 dawugui 的回复:]
SELECT 编号,姓名,性别 FROM T1
union all
SELECT 编号,姓名,性别 FROM T2
ORDER BY t1.编号


select * from
(
SELECT 编号,姓名,性别 FROM T1
union all
SELECT 编号,姓名,性别 FROM T2
) t
ORDER BY 编号
[/Quote]

这是2张表排序，我只对T2排序

[gll062]

把t2中的数据排序后放入临时表中，让后在对临时表操作