title: Get data from multiple SELECT sub-queries for reporting from MySQL database
body: <p>I'm trying to achieve is to create one complex query consisting of a few sub-queries.  The idea is to give it to a business person to run on a weekly basis to pull reporting data.</p>
  
  <p>The effect would be similar to the query below, where all data from many tables are displayed in one result.</p>
  
  <pre><code>select * from table1, table2, table3
  </code></pre>
  
  <p>So I need something like, but it's not working.</p>
  
  <pre><code>select 
      (select * from   table1 where ...... ) as table1,
      (select * from   table2 where....... ) as table2
  </code></pre>
  
  <p>Manually, I could run the sub-queries separately, then manually append the results into one big excel sheet.  But I want to make it easier for the business person to do this, and minimize errors.</p>
  
  <p>Is this possible in MySQL?  </p>
  
  <p>The reason for this is I'm converting a legacy Oracle PIVOT SQL statements into the MySQL equivalence, and the sub-queries are pretty complex.</p>
  
  <p>I can provide the Oracle SQL if needed.</p>
  
  <p>Much appreciated as always.</p>