select top 10 *
from (select buy_id,detail_id,release_date,title
from em_buy
where active=1
union all
select abuy_id,detail_id,release_date,title
from em_abuy
where active=1
order by release_date desc
) a
from (select buy_id,detail_id,release_date,title
from em_buy
where active=1
union all
select abuy_id,detail_id,release_date,title
from em_abuy
where active=1
order by release_date desc
) a
--这样试一下,没测试
select top 10 * from ((select buy_id,detail_id,release_date,title from em_buy where active=1) union all (
select abuy_id,detail_id,release_date,title from em_abuy where active=1) order by release_date desc ) t
from (select buy_id,detail_id,release_date,title
from em_buy
where active=1
union all
select abuy_id,detail_id,release_date,title
from em_abuy
where active=1
) a
order by release_date desc
from (select buy_id,detail_id,release_date,title from em_buy where active=1
union all
select abuy_id,detail_id,release_date,title from em_abuy where active=1)t
order by t.release_date desc
select top 10 * from (select buy_id,detail_id,release_date,title from em_buy where active=1 union all ( --这个括号是多余的吧
select abuy_id,detail_id,release_date,title from em_abuy where active=1) t --这儿加个别名
order by release_date desc ) --此括号亦多余
from (select buy_id,detail_id,release_date,title
from em_buy
where active=1
union all
select abuy_id,detail_id,release_date,title
from em_abuy
where active=1
) a
order by release_date desc
from (select buy_id,detail_id,release_date,title
from em_buy
where active=1
union all
select abuy_id,detail_id,release_date,title
from em_abuy
where active=1
) a
order by release_date desc