Question

asp多表查询,并按时间排序问题!

表一:news1 排序字段为active_date按倒序排
表二:news2 排序字段为active_date按倒序排
表三:news3 排序字段为active_date按倒序排

从这三个表中取出最近的8条新闻,并按与当前时间最近的倒序排列
请问怎么用联合查询做到?
注: access数据库
好像两位高手的方法都不行哦!~出错!
Microsoft OLE DB Provider for ODBC Drivers 错误 '80040e21'

ODBC 驱动程序不支持所需的属性。

/index1.asp，行 167

Answer 1

select top 8 * from
(
select top 8 * from news1 order by active_date desc
union all
select top 8 * from news2 order by active_date desc
union all
select top 8 * from news3 order by active_date desc
)
as a
order by active_date desc

Answer 2

select top 8 from (select * from news1 union news2 union news3) order by active_date desc

Answer 3

sql="select Top 8 from(select * news1.active_date,news2.active_date,news3.active_date,from news1,news2,news3) order by active_date desc"