title: Create trending report from multiple tables
body: <p>I have 10 tables in my system that I need to get some counts from.  The 10 tables we have are one for each month, starting in January until now means we have 10 for now.  These tables contain customers.  Each month some previous customers are no longer customers (we have lost some) and each month we gain some customers.  Overall we are increasing our customer base so each month there will be more total customers than the previous month.  I'd like to do a trending report to show just how many new customers are added to our system each month.</p>
  
  <p>I have these tables in SQL and what I'd like to do is start with the total in January.  Then I need to have the additional count of customers for February, March, April, and so on.  Each month will be compared to the total count of the previous month (March additional members will be compared to the March total mebers to determine the difference).  I'd like to get the output to look like this:</p>
  
  <pre><code>Jan Total Members       Feb Add'l Members       March Add'l Members      April Add'l Members
  45500                   3300                    2299                        3205
  </code></pre>
  
  <p>Is there a way to put together a query to aggregate this data?  I can easily do a Count(*) on the tables to get a total and use a LEFT JOIN with an IS NULL clause to get the actual customers of additional members but I need to manually copy the results.  I'd like to run one query to do the work as we may need to do this over and over again in the future.</p>