合并查询结果

[the_Fm]

在MSSQL自带的pubs中执行如下查询
USE pubs
select * from authors where au_id like '%72%'
select * from authors where contract='1'

现在希望将两条SELECT的结果合并（以or的方式，如果又相同的结果只取一个）
例如
=====
select * from authors where (au_id like '%72%') or (contract='1')

希望能给予另外一种方法，就是将这些查询结果先添加到某个临时表里，然后一次查询出来，可能吗？（如果你问为什么，原因是，那样做程序好写得多）

[OpenVMS]

select distinct * from (
select * from authors where au_id like '%72%'
union all
select * from authors where contract='1') a

[hjhing]

select * into #temp from authors where (au_id like '%72%') or (contract='1')

select * from #temp

drop table #temp

[the_Fm]

select * into #temp from authors where (au_id like '%72%') or (contract='1')

我的确希望使用select into 可是希望的是
select * into #temp from authors where au_id like '%72%'
select * into #temp from authors where au_id like contract='1'
select * from #temp

drop table #temp

系统的提示是#temp已经存在
如果只用一句sql好像不能简化我的工作

[gzh_seagull]

create table #tmp
select * into #tmp from authors where au_id like '%72%'
select * into #tmp from authors where au_id like contract='1'
select * from #tmp

drop table #tmp

[happydreamer]

select * into #temp from authors where au_id like '%72%'

insert into #temp select * from authors where au_id like contract='1'