Get number of comments within a forum : <p>I have 3 tables:</p>

<p>forums, threads, comments</p>

<p>I would like to write a query to get the number of comments within a forum.</p>

<p>Every row in threads has a column "fid" which shows which forum the thread was posted in.</p>

<p>Every row in comments has a column "tid" which shows which thread the comment was posted on.</p>

<p>Do you have any idea?</p>

<p>Thanks.</p>
