这2个表如何连接查询出需要的内容？

[sagegz]

第1个表Posts
列：PostsID Title
第2个表Reply
列:ReplyID Conten PostsID(表Posts的外键)

请问：如何查出每个PostsID中的内容（即PostsID和Title列）以及对应的PostsID在表Reply的记录数。谢谢～！

[pgy8288]

SELECT A.PostsID, A.Title, B.CNT
FROM Posts a
INNER JOIN (SELECT PostsID, COUNT(*) AS cnt FROM Reply GROUP BY PostsID) B
   ON A.PostsID = B.PostsID

[--小F--]

select
  a.*,b.num
from
  Posts a,
  (select PostsID,count(1) as num from Reply group by PostsIDZ)b
where
  a.PostsID=b.PostsID

[burningbloog]

学习。

[yubofighting]

[Quote=引用 1 楼 pgy8288 的回复:]
SQL code

SELECT A.PostsID, A.Title, B.CNT
FROM Posts a
INNER JOIN (SELECT PostsID, COUNT(*) AS cnt FROM Reply GROUP BY PostsID) B
ON A.PostsID = B.PostsID
[/Quote]
+

[dearbinge]

[Quote=引用 2 楼 fredrickhu 的回复:]
SQL code
select
a.*,b.num
from
Posts a,
(select PostsID,count(1) as num from Reply group by PostsIDZ)b
where
a.PostsID=b.PostsID
[/Quote]
+1