大家帮忙看下我的视图哪里有错?

create view v_Forums_Forums
(CategoryID,
CategoryName, 
CategoryImageUrl,
CategoryPosition,
ForumID,
ForumName,       
ForumDescription,
ForumPosition,
ForumTopics,
ForumPosts,
ForumLastPostDate)
as
select Forums_Categories.CategoryID, Forums_Categories.CategoryName, Forums_Categories.CategoryImageUrl,  Forums_Categories.CategoryPosition, Forums_Forums.ForumID, Forums_Forums.ForumName,        Forums_Forums.ForumDescription,Forums_Forums.ForumPosition,
       (SELECT COUNT(*) FROM  Forums_Topics
         WHERE  Forums_Topics.ForumID = Forums_Forums.ForumID)  ,
       (SELECT COUNT(*) FROM  Forums_Topics WHERE   Forums_Topics.ForumID = Forums_Forums.ForumID) +
        (SELECT COUNT(*) FROM  Forums_Replies WHERE      Forums_Replies.ForumID = Forums_Forums.ForumID) ,
        (SELECT     MAX(AddedDate)  AS dates FROM  (SELECT  ForumID, AddedDate FROM   Forums_Topics
          UNION all
         SELECT     ForumID, AddedDate FROM         Forums_Replies)
        WHERE   dates.ForumID = Forums_Forums.ForumID)  
from Forums_Categories,Forums_Forums where Forums_Categories.CategoryID = Forums_Forums.CategoryID;