＋设为首页 ＋添加到收藏夹
表字段：iPostID,sHeader,iMainPostID.(帖子iD,标题，主帖子ID：为0则是主帖，大于0则为子贴)
现要查出主贴的id,sHeader,和回复帖子数。
该怎么写sql语句啊？
select iPostId,sHeader,(select count(*) from test where iMainPostId=a.iPostId) Count from test a
where imainpostid=0
ALTER PROCEDURE dbo.StoredProcedure13
/*
(
@parameter1 datatype = default value,
@parameter2 datatype OUTPUT
)
*/
AS
SELECT iPostID, sHeader,(SELECT COUNT(*) FROM BBS_Test WHERE (iMainPostID = bbs.iPostID)) topicCount
FROM BBS_Test bbs
WHERE (iMainPostID = 0)
RETURN
SELECT iPostID, sHeader,(SELECT COUNT(*) FROM TABLE WHERE (topID = a.iPostID)) countID
FROM table a WHERE (iMainPostID = 0)
