随笔

最新推荐文章于 2022-12-03 20:34:04 发布

diniushu8825

最新推荐文章于 2022-12-03 20:34:04 发布

阅读量65

点赞数

原文链接：http://www.cnblogs.com/luckjun/archive/2011/06/21/2086022.html

版权

SELECT  p.* ,
        CASE  WHEN u.tongji IS null THEN 0 ELSE u.tongji END
FROM    dbo.AS_Project AS p
        LEFT JOIN ( SELECT  COUNT(0) AS tongji ,
                            ProjectId
                    FROM    dbo.AS_Url
                    WHERE   ProjectId IN ( SELECT   id
                                           FROM     dbo.AS_Project )
                    GROUP BY ProjectId
                  ) AS u ON p.id = u.ProjectId

转载于:https://www.cnblogs.com/luckjun/archive/2011/06/21/2086022.html