title: SELECT COUNT(*) in a Left Join
body: <p>So, I have a simple left join:</p>
  
  <pre><code>SELECT 
        a.SetNumber, 
        a.SetID, 
        COUNT(a.QuantityOwned) AS Pwnd,
        b.ImageURL, 
        COUNT(a.Quantity) AS Cmplt
  FROM a
  LEFT JOIN b ON a.SetNumber = b.Number
  GROUP BY a.SetID
  </code></pre>
  
  <p>That produces this:</p>
  
  <pre><code>SetNumber 11 21 13
  
  SetID 1 2 1
  
  Pwnd 45 33 50
  
  Cmplt 50 36 50
  
  ImgURL a.jpg b.jpg c.jpg
  </code></pre>
  
  <p>Which is fine, when I use the data, but I want a >> arrow in my pagination and to do that I would like to get the amount of rows, ie the desired result in this case is:</p>
  
  <pre><code>3
  </code></pre>
  
  <p>I know I can count rows with <code>COUNT(*)</code> in one table, but how do I do it in a left join?</p>