count,多表 SELECT A.SiteSortID,B.Name,count(*) as Num FROM Article A,SiteSort B WHERE B.ID=A.SiteSortID and A.IsVisible = @IsVisible GROUP BY A.SiteSortID ,B.Name 以前还以为不可以..