title: COUNT(*) from multiple tables in MySQL
body: <p>How do I go about selecting COUNT(*)s from multiple tables in MySQL?</p>
  
  <p>Such as:</p>
  
  <pre><code>SELECT COUNT(*) AS table1Count FROM table1 WHERE someCondition
  JOIN?? 
  SELECT COUNT(*) AS table2Count FROM table2 WHERE someCondition
  CROSS JOIN? subqueries?
  SELECT COUNT(*) AS table3Count FROM table3 WHERE someCondition
  </code></pre>
  
  <p><strong>Edit:</strong></p>
  
  <p>The goal is to return this:</p>
  
  <pre><code>+-------------+-------------+-------------+
  | table1Count | table2Count | table3Count |
  +-------------+-------------+-------------+
  | 14          | 27          | 0           |
  +-------------+-------------+-------------+
  </code></pre>