SQL 求子表合计数右连主表

1、拼SQL

SELECT   b.cou AS Cou, a.PID, a.MID, a.SN, a.Name, a.CanUse, a.Phone, a.Fax, a.EMail, a.PostCode, a.Address, a.CoHttp
FROM   dbo.tbClientList AS a  LEFT OUTER JOIN
        (SELECT  max(MID) AS MID,COUNT(*) as cou  FROM dbo.tbClientBank  GROUP BY MID)  AS b
         ON a.PID = b.MID

2、加条件

SELECT  b.cou AS Cou, a.PID, a.MID, a.SN, a.Name, a.CanUse, a.Phone, a.Fax, a.EMail, a.PostCode, a.Address, a.CoHttp
FROM  dbo.tbClientList AS a LEFT OUTER JOIN
             (SELECT     MAX(MID) AS MID, COUNT(*) AS cou
                 FROM   dbo.tbClientBank
                  GROUP BY MID) AS b ON a.PID = b.MID
WHERE     (a.PID = 2)