title: mysql count(*) from multiple tables
body: <p>I have a MYSQL database that contains data on my companies customers as they use our services each day.</p>
  
  <p>each table in the database represents one 24 hour period and all customer transactions that took place in that period.</p>
  
  <p>I would like to count the total transactions over a number of days</p>
  
  <p>so far I have a select statement that does the following </p>
  
  <pre><code>select 
    (
      select count(customer) from 2010Dec28 
      where customer='&lt;customer name&gt;'
    ) as t1,
    (
      select count(customer) from 2010Dec29 
      where customer='&lt;customer name&gt;'
    )as t2;`
  </code></pre>
  
  <p>but this returns the result as two separate counts</p>
  
  <pre><code>| t1   | t2    |
  | 1438 | 16282 |
  1 row n set (0.00 sec)`
  </code></pre>
  
  <p>My question is how can I generate the sum of these two results  without having to do so in my application code.</p>