怎么把两条sql语句查询出的数据放在一个查询结果里 sql2005

[SvenCows]

select top 1 * from Purgdtary where ESOrdersId =58 and PurgErrorTime is not null and purgState>0 order by abs(datediff(d,PurgErrorTime,getdate())) desc

select top 1 * from Purgdtary where ESOrdersId =58 and PurgEndTime is not null and purgState>0 order by abs(datediff(d,PurgEndTime,getdate())) asc

[快溜]

with cte1 as
(select top 1 * from Purgdtary where ESOrdersId =58 and PurgErrorTime is not null 
  and purgState>0 order by abs(datediff(d,PurgErrorTime,getdate())) desc)
,cte2 as(select top 1 * from Purgdtary where ESOrdersId =58 and PurgEndTime is not null 
  and purgState>0 order by abs(datediff(d,PurgEndTime,getdate())) asc)

select * from cte1 union all select * from cte2

[中国风]

select * from (select top 1 * from Purgdtary where ESOrdersId =58 and PurgErrorTime is not null and purgState>0 order by abs(datediff(d,PurgErrorTime,getdate())) desc )t
union all 
select * from (select top 1 * from Purgdtary where ESOrdersId =58 and PurgEndTime is not null and purgState>0 order by abs(datediff(d,PurgEndTime,getdate())) asc)t

[cd731107]

select *
from 
(select top 1 * from Purgdtary where ESOrdersId =58 and PurgErrorTime is not null 
and purgState>0 order by abs(datediff(d,PurgErrorTime,getdate())) desc  
) ta,
(select top 1 * from Purgdtary where ESOrdersId =58 and PurgEndTime is not null 
and purgState>0 order by abs(datediff(d,PurgEndTime,getdate())) asc
) tb

[SvenCows]

谢谢了,都可以 稍后结帖

[h892359495]

SELECT count(*) as sum from hacconf.resource,hacconf.auditor_session_author,hacref.session where starttime>=1346169600 and starttime<=1346255999 and hacref.session.appname=hacconf.resource.name and hacconf.resource.dev_id=hacconf.auditor_session_author.dev_id and hacconf.auditor_session_author.manager_id=3 and endtime > 1
UNION SELECT count(*) as sum from hacref.session where starttime>=1346169600 and starttime<=1346255999 and endtime = 1)
我的查询结果是sum有两个数据，我想请问怎么把两个数据起来得到一个数据