title: SQL Count from INNER JOIN
body: <p>How can I select the count from an inner join with grouping?</p>
  
  <pre><code>SELECT COUNT(table1.act) FROM table1
  INNER JOIN table2 ON table1.act = table2.act
  GROUP BY table1.act
  </code></pre>
  
  <p>This will return the count of act's found in table2.</p>
  
  <p>Adding</p>
  
  <pre><code> SELECT table1.act, COUNT(table1.act) AS test
  </code></pre>
  
  <p>Returns</p>
  
  <pre><code>act     test
  ------- ----
  17682   3
  17679   3
  17677   3
  11636   1
  11505   1
  </code></pre>
  
  <p>I want to receive the count of act's found total.</p>
  
  <p>So I want to get 5. Can you help?</p>