求一条sql语句

[zhmvb]

SELECT News_News.NewsID, News_News.IndexTitle,
News_Column.Newscolumn
FROM News_News INNER JOIN
News_Column ON News_Column.ColumnID = News_News.ColumnID

根据上面的sql产生了下面的数据：
newsid indexTitle Newscolumn
1 标题xxxxxx 综合新闻
2 标题xxxxxx 科教文卫
3 标题xxxxxx 科教文卫
4 标题xxxxxx 综合新闻
5 标题xxxxxx 科教文卫

现在求一条sql，要求是在这个结果上在加一列，用于显示此类新闻的总数，比如:
newsid indexTitle Newscolumn Rscount
1 标题xxxxxx 综合新闻 2
2 标题xxxxxx 科教文卫 3
3 标题xxxxxx 科教文卫 3
4 标题xxxxxx 综合新闻 2
5 标题xxxxxx 科教文卫 3

谢谢各位！

[zeroyou]

手头现在没有sqlexporler，用group by实施呢？

[jiang8282]

SELECT News_News.NewsID, News_News.IndexTitle,
News_Column.Newscolumn, count(News_News.id) as Rscount
FROM News_Column left JOIN News_News
ON News_Column.ColumnID = News_News.ColumnID
group by News_News.NewsID, News_News.IndexTitle,News_Column.Newscolumn,

[新鲜鱼排]

select * from
(
SELECT News_News.NewsID, News_News.IndexTitle,
News_Column.Newscolumn
FROM News_News INNER JOIN
News_Column ON News_Column.ColumnID = News_News.ColumnID
) a,
(
SELECT count(News_Column.Newscolumn) [count]
FROM News_News INNER JOIN
News_Column ON News_Column.ColumnID = News_News.ColumnID
group by News_Column.Newscolumn
) b