title: Help with count();
body: <p>I've got 2 tables. 
  One called Video,  and one called ThumbsUp. </p>
  
  <pre><code>Video    -&gt; Id, Path, Thumbnail, Profile
  
  ThumbsUp -&gt; Id, Owner, Video
  </code></pre>
  
  <p>I need to pull every Video record <code>WHERE PROFILE = 2</code>, 
  And <code>COUNT(ThumbsUp.Id)</code> the number of likes for each video, 
  Even if that video does not have any thumbs up. </p>
  
  <p>Any help is appreciated. . .</p>