如何把三个表中字段名不同的记录查询出来？

[baixp123]

如有A，B，C三个表，三个表中都有COMPANY字段，如果抽取三个表中字段值唯一的记录？
a company b company c company
a a e
b d f
c b c
a b c
b
我现在要的结果是 a b c d e f

[客家族_Shark曾_小凡仙]

Select Company
From Comapny a
Gorup by Company

[$扫地僧$]

CREATE PROCEDURE Temp_T(@Temp2 as varchar(100) OUTPUT)
as
set @Temp2=' '
select @Temp2=@Temp2+T.company from
(select company from a
union
select company from b
union
select company from c) T
set @Temp2=STUFF(@Temp2,1,1,'')


DECLARE @Temp as varchar(100)
exec Temp_T @Temp OUTPUT
print @Temp

[Well]

select distinct company
from
(
select company
from a
union all
select company
from b
union all
select company
from c
) D

[iwl]

select company
from a
union
select company
from b
union select company
from c

[ReViSion]

a company b company c company
a a e
b d f
c b c
a b c

--试下这个
select distinct company form
(Select company from a
union all
select company from b
union all
select company from c)a

[lishengyu]

select company
from a
union
select company
from b
union select company
from c

[TWWH]

Hopewell_Go(好的在后頭﹗希望更好﹗﹗) 的正确。
别动不动就用存储过程，累人。

[Well]

TWWH() ( )
哈哈
感覺你好好玩。