title: combine two temporary tables into one table, but keep all the column names
body: <p>I need to create two temporary tables, then join them together into one table and keep all of the column names for both tables and the data.  Using Mysql</p>
  
  <pre><code>CREATE TEMPORARY TABLE tenant_invoices
      SELECT * FROM invoices
  
  CREATE TEMPORARY TABLE tenant_payments
      SELECT * FROM payments
  </code></pre>
  
  <p>How do I go about doing this using MYSQL?</p>
  
  <p>Thanks.</p>