sql表关联问题

[herc007]

我有两个表Bs_Vots,Bs_Newn
Bs_Vots表中Vots_ID和Bs_Newn表中Newn_VotsId是关联的
我想统计Bs_Newn表中Newn_VotsId同一个数值最多的前五条,并通过关联Bs_Vots表中的Vots_User中的内容?
Bs_Vots:
Vots_ID Vots_User
1 a12
2 b23
3 c34

Bs_Newn:
Newn_ID Newn_VotsId
1 2
2 1
3 2
4 1
5 2
6 3
我想要的结果是:
b23
a12
(Bs_Newn表中Newn_VotsId有3个2是一样的,调用Bs_Vots表中Vots_ID为2的Vots_User内容)
请问各位大哥怎么解决,小弟想了几天也没好方法??????

[sy_binbin]

select Vots_User from Bs_Vots where Vots_ID in (SELECT top 5 Newn_VotsId FROM Bs_Newn group by Newn_VotsId order by COUNT(Newn_VotsId) desc)

[herc007]

有错误,还是不行啊,急.....................

[myp506]

SELECT Bs_Vots.Vots_User FROM Bs_Newn INNER JOIN Bs_Vots ON Bs_Newn.Newn_VotsId = Bs_Vots.Vots_ID
GROUP BY Bs_Vots.Vots_User
ORDER BY COUNT(Bs_Newn.Newn_VotsId) DESC

[myp506]

SELECT TOP 5 Bs_Vots.Vots_User
FROM Bs_Newn INNER JOIN Bs_Vots ON Bs_Newn.Newn_VotsId = Bs_Vots.Vots_ID
GROUP BY Bs_Vots.Vots_User
ORDER BY COUNT(Bs_Newn.Newn_VotsId) DESC

[herc007]

谢谢.............

[13617650029]

SELECT TOP 5 dbo.Bs_Vots.Vots_User
FROM dbo.Bs_Vots INNER JOIN
      dbo.bs_newn ON dbo.Bs_Vots.vots_ID = dbo.bs_newn.newn_VotsId
GROUP BY dbo.Bs_Vots.Vots_User
ORDER BY COUNT(dbo.bs_newn.newn_VotsId) DESC