摘要： 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 以前还以为不可以.. 阅读全文