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

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

------解决方案--------------------

SQL code

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

------解决方案--------------------

SQL code

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