title: JOINING TABLES AND COUNTING
body: <p>I'm trying to count total number of child records from a table but seems not to work. When in left join is counts rather the total number of records in the parent table rather than the child. </p>
  
  <pre><code>SELECT Count(comment) as total
  FROM dbo.photo_comment  LEFT JOIN users_pics ON photo_comment.resp_email = users_pics.email
  WHERE photo_comment.wardrobe = MMColParam
  </code></pre>
  
  <p>photo_comment is the parent table and users_pics is the child table. What i want the query to do is to count the total number of comments on a picture</p>