怎么样用sql做一个销量排行

select top 10 ID,Title from KS_Product where ID=(SELECT top 10 First(KS_OrderItem.ProID) AS [ProID 字段]
FROM KS_OrderItem
GROUP BY KS_OrderItem.ProID
HAVING (((Count(KS_OrderItem.ProID))>=1))
ORDER BY Count(KS_OrderItem.ProID) DESC;)

上面的还有问题，这个测试过了

SELECT TOP 10 KS_Product.ID, KS_Product.Title
FROM KS_OrderItem INNER JOIN KS_Product ON KS_OrderItem.ProID = KS_Product.ID
GROUP BY KS_OrderItem.ProID, KS_Product.ID, KS_Product.Title
HAVING (((Count(KS_OrderItem.ProID))>=1))
ORDER BY Count(KS_OrderItem.ProID) DESC;

改成这样可以了

select top 10 ID,Title from KS_Product where ID in (SELECT top 10 First(KS_OrderItem.ProID) AS [ProID 字段]
FROM KS_OrderItem
GROUP BY KS_OrderItem.ProID
HAVING (((Count(KS_OrderItem.ProID))>=1))
ORDER BY Count(KS_OrderItem.ProID) DESC;)

我是这样写的，但是会报错

Microsoft JET Database Engine 错误 '80004005'

子查询最多能返回一个记录。

/KS_Cls/Kesion.Label.SQLCls.asp，行 190