多表查询问题,

[古侠]

T1表中有一列（L）值分别是A，B，C
T2表中也有一列（L）值分别是A，B，D


怎样取得A，B，C，D

[zlp321002]

select L from T1
union
select L from T2

[-狙击手-]

select L from t1 union
select L from t2

[mislrb]

select t.l from (
select l from t1
union
select l from t2
) t
order by t.l

[-狙击手-]

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

*/