34,594
社区成员
发帖
与我相关
我的任务
分享
SELECT
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
select a.unitname,d.cname,sum(cScore) as cscore
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
SELECT
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='单位'
select
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