要根据每个单位查询出每个季度的分数
四张表
用户userZb 表 iid编号 userid单位编号
季度积分rcpgscore表 uzbid对应userzb表的id cScore分数 jdid对应rcpg表的id
季度rcpg表 iid编号 cname名称
单位unit 表 uid编号 unitname名称
四张表
用户userZb 表 iid编号 userid单位编号
季度积分rcpgscore表 uzbid对应userzb表的id cScore分数 jdid对应rcpg表的id
季度rcpg表 iid编号 cname名称
单位unit 表 uid编号 unitname名称
d.unitname,b.cScore
from
userZb a,rcpgscore b,rcpg c,unit d
where
a.id=b.uzbid
and
b.jdid=c.id
and
a.userid=d.uid
c.*,b.*
FROM userZb AS a
INNER JOIN rcpgscore AS b ON a.iid=b.uzbid
INNER JOIN rcpg AS c ON c.iid=b.jdid
INNER JOIN unit AS d ON d.uid=a.userid
WHERE d.unitname='单位'
from unit a inner join userZb b on a.uid=b.userid
inner join rcpgscore c on b.uzbid=c.id
inner join rcpg d on d.iid=c.jdid
group by a.unitname,d.cname
d.unitname,c.cname,SUM(cScore) AS cScore
FROM userZb AS a
INNER JOIN rcpgscore AS b ON a.iid=b.uzbid
INNER JOIN rcpg AS c ON c.iid=b.jdid
INNER JOIN unit AS d ON d.uid=a.userid
GROUP BY d.unitname,c.cname