3.2w+
社区成员
- 主页
- 基础类
- 应用实例
- 新技术前沿
...全文
请发表友善的回复…
发表回复
-狙击手- 2006-01-19
declare @T1 table(L char(1))
insert @t1 select 'A' union select 'B' union select 'C'
declare @T2 table(L char(1))
insert @t2 select 'A' union select 'B' union select 'D'
select L from @t1 union
select L from @t2
/*
L
----
A
B
C
D
*/
insert @t1 select 'A' union select 'B' union select 'C'
declare @T2 table(L char(1))
insert @t2 select 'A' union select 'B' union select 'D'
select L from @t1 union
select L from @t2
/*
L
----
A
B
C
D
*/
mislrb 2006-01-19
select t.l from (
select l from t1
union
select l from t2
) t
order by t.l
select l from t1
union
select l from t2
) t
order by t.l
-狙击手- 2006-01-19
select L from t1 union
select L from t2
select L from t2
zlp321002 2006-01-19
select L from T1
union
select L from T2
union
select L from T2