MYSQLÇóƽ¾ùÖµµÄÎÊÌ⣬¼±£¡

²ÉÓÃPHP+MYSQL
±í company
userid  name  status
1        Ìì²Å    1
2        Ó¢ÐÛ    1
3        ¹í²Å    0

±í dp
gid  userid  sort1  sort2
1      1        4      3
2      2        2      3
3      2        2      1
4      2        3      2
5      2        3      2

Áгö  status=1 µÄÇé¿öϱícompanyÖеÄÊý¾Ý²¢¼ÆËã±ídpÖÐuseridÖµÏàͬµÄsort1ºÍsort2µÄƽ¾ùÖµ
name  avgsort1  avgsort2
Ìì²Å    4          3
Ó¢ÐÛ    2.5        2

Çë½Ì¸ßÊÖÓÃSQLÓï¾äÔõÑùʵÏÖ°¡£¿£¿£¿

---

SELECT c.*,AVG(d.sort1) avgsort1,AVG(d.sort2) avgsort2
from company c,dp d
WHERE c.userid=d.userid AND c.status=1
GROUP BY c.userid;

---

SQL code:
select name,avg(sort1) as avgsort1,avg(sort2) as avgsort1
from company c inner join dp d using (userid)
where status=1
group by name

---

SE