title: SQL: Count in join not working
body: <p>I have an SQL query where I simply join two tables. One table contain comments and the other is the user table. I join the tables to in a simple manner get user information about the user who wrote the comment (username) at the same time get the comment (comment text etc.).</p>
  
  <p>Now I want to count the number of comments to write the correct number of comments on the top of the page. I do this by adding a COUNT, and an alias to save the value.</p>
  
  <p>When I echo numCount, I get the correct value of comments, but I get no comments in my comment loop. As soon as I remove the count, I get all comments again. What am I doing wrong?</p>
  
  <pre><code>SELECT
  ncID, ncText, ncDate,
  uID, uName, uImageThumb,
  COUNT(a.ncID) AS numComments
  FROM tblNewsComments a LEFT JOIN tblUsers b
  ON a.ncUserID = b.uID
  WHERE  a.ncNewsID = $newID 
  ORDER BY ncDate DESC
  </code></pre>