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*/
select L from t2
select l from t1
union
select l from t2
) t
order by t.l
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*/