ÎʸöSQLÔõôд

ÏÖÔÚÓÐ2¸ö±í
Group±í
SQL code:

GroupID GroupName
1 A×é
2 B×é



UserGroup±í
SQL code:

ID UserID GroupID
1 3 1
2 4 1



ÏÖÔÚÎÒÏëÈ¡³öÕâÑùµÄÊý¾Ý
GroupID  GroupName    Group±íÖеÄÓû§×ÜÊý

ÎÒÊÇÕâÑùдµÄ
SQL code:

SELECT MAX(G.groupid) as groupid,MAX(groupname) as groupname,count(userid) AS groupcount from [Group] G JOIN UserGroup U ON G.groupid = U.groupid GROUP BY G.groupid



µ«ÊÇÈ¡³öÀ´µÄÊý¾ÝÊÇÕâÑùµÄ
SQL code:

groupid groupname groupcount
1 A×é 2



µ«ÊÇÎÒÏëҪȡ³öÀ´µÄÊý¾ÝÊÇÕâÑùµÄ
SQL code:

groupid groupname groupcount
1 A×é 2
2 B×é 0



ÇëÎÊÓ¦¸ÃÔõôд£¿Ð»Ð»£¡

---

JOIN¸Ä³ÉLEFT JOIN

---

Ò