access去除重复记录,在线等,谢谢了

表products
表xl
现在我想读取xl里面的10条记录,但是xl_id要等于products表里的p_xlid,并且p_xlid只取products里面的以p_browsecount  DESC排序的前10条
我用的这个取出来有重复记录
SELECT TOP 10 xl_info.xl_id,xl_info.xl_name from products,xl_info WHERE (xl_info.xl_id=products.p_xlid) ORDER BY products.p_browsecount DESC

---

SELECT distinct TOP 10 xl_info.xl_id,xl_info.xl_name from products,xl_info WHERE (xl_info.xl_id=products.p_xlid) ORDER BY products.p_browsecount DESC

---

select  *  from  表名  where  name  in  (select  name  from  表名  having  count(name)>1)

---

加关键字 distinct

---

异常详细信息: System.Data.OleDb.OleDbException: ORDER BY 子句与 (products.p_browsecount)  DISTINCT 冲突。

---

用内连接啊！！！用内连接就没有重复的了
SQL code:

select top 10 b.xl_id,b.xl_name
from products as a inner JOIN xl_info as b
ON b.xl_id=a.p_xlid) ORDER BY a.p_browsecount DESC


-.-!

---

SQL code:

select top 10 b.xl_id,b.xl_name
from products as a inner JOIN xl_info as b
ON b.xl_id=a.p_xlid ORDER BY a.p_browsecount DESC


-.-!这个。。

---

SQL code

---

Code highlighting pro