34,594
社区成员
发帖
与我相关
我的任务
分享
SELECT SubjectID,ResourceID,SubjectName,ResourceName, COUNT(B.TID) COUNTS
FROM t_resourcefile B
WHERE RecordTime>='2015-02-08 00:00:0' and RecordTime<='2015-03-20 23:59:59'
GROUP BY SubjectID, ResourceID
ORDER BY SubjectID
--MYSQL的动态处理我还得查一下,先处理成竖的吧
SELECT T3.TID,T3.TName,T3.SubjectID,T3.SubjectName
,COUNT(T4.TID)COUNTS
FROM(
SELECT T1.TID,T1.TName,T2.SubjectID,T2.SubjectName
FROM 资源类型 T1,
(SELECT SubjectID,SubjectName FROM t_resourcefile GROUP BY SubjectID,SubjectName)T2
)T3 LEFT JOIN t_resourcefile T4 ON T3.TID=T4.ResourceID AND T3.SubjectID=T4.SubjectID
GROUP BY T3.TID,T3.TName,T3.SubjectID,T3.SubjectName
没有数据会显示0