请教：如何筛选相同的数据。

[axinko]

提取相同的表的数据，但是如果二个表（KS_Article ，KS_U_spxx），每个表已经相同数据Author只提取一条数据，但是如果二个表都有相同的Author又有二个Author重复，请问怎样再排除一个（时间降序）。感谢。可能表达不清，抱歉

set rs=server.CreateObject("adodb.recordset")
rs.open "SELECT * FROM KS_Article where KS_Article.ID in(select max(KS_Article.ID) from KS_Article group by KS_Article.Author)and KS_Article.Author in("&Username&") UNION SELECT * FROM KS_U_spxx where KS_U_spxx.ID in(select max(KS_U_spxx.ID) from KS_U_spxx group by KS_U_spxx.Author)and KS_U_spxx.Author in("&Username&") order by adddate desc",conn,1,1


显示数据
广东省中国青年旅行社　刚发布：[散拼产品]45454 10000 2009-10-20 23:00:37 --这是KS_Article 表的
广东省中国青年旅行社　刚发布：[国内旅游]45454 10000 2009-10-14 16:56:35 --这是KS_U_spxx 表的


但是我只有一个其中一个数据，请问如何查询？？谢谢

[ACMAIN_CHM]

SELECT * FROM KS_Article a
where Author in("&Username&") 
and not exists (select 1 from KS_Article where Author=a.Author and id>a.id)
and not exists (select 1 from KS_U_spxx where Author=a.Author and id>a.id)
union all
SELECT * FROM KS_U_spxx b
where Author in("&Username&") 
and not exists (select 1 from KS_Article where Author=b.Author and id>b.id)
and not exists (select 1 from KS_U_spxx where Author=b.Author and id>b.id)

[ACMAIN_CHM]

当您的问题得到解答后请及时结贴.
http://topic.csdn.net/u/20090501/15/7548d251-aec2-4975-a9bf-ca09a5551ba5.html