 <p>Do not mix sub-query and join logic. Use only one of them. I prefer sub-select.</p> <pre><code>SELECT tblForumSubGroups_1.id, tblForumSubGroups_1.GroupID, tblForumSubGroups_1.SubGroupTitle, tblForumSubGroups_1.SubGroupDesc, (SELECT COUNT(*) FROM dbo.tblForumPosts WHERE dbo.tblForumSubGroups.id = dbo.tblForumPosts.SubGroupID) AS Expr1 FROM dbo.tblForumSubGroups AS tblForumSubGroups_1 </code></pre>