现在有3个表
部门表CClass
用户表User
稿件表xl_NewsUser表里字段ClassID对应CClass表的ID
xl_News表里字段UserID对应User表的ID现在要得出投稿数量由多到少的部门排行以及部门投稿数量
部门表CClass
用户表User
稿件表xl_NewsUser表里字段ClassID对应CClass表的ID
xl_News表里字段UserID对应User表的ID现在要得出投稿数量由多到少的部门排行以及部门投稿数量
FROM dbo.用户表 INNER JOIN
dbo.稿件表 ON dbo.用户表.ID = dbo.稿件表.UserID INNER JOIN
dbo.部门表 ON dbo.用户表.ClassID = dbo.部门表.ID
GROUP BY dbo.部门表.classname
ORDER BY 数量 DESC
谢谢各位的指导,正确答案:
SELECT COUNT(xw_News.UserID) AS sss, CClass.classname
FROM ((CClass INNER JOIN
[User] ON CClass.ID = [User].ClasID) INNER JOIN
xw_News ON [User].ID = xw_News.UserID)
GROUP BY CClass.classname
ORDER BY sss DESC