title: Define table names for results of multiple SQL selects in a single query
body: <p>For example if I run the following query:</p>
  
  <pre><code>select * from table1
  select * from table2
  </code></pre>
  
  <p>And run it with a DB adapter (C#) I get a dataset with two tables.
  How can I define the names for the result tables in SQL?</p>
  
  <p>I can only do this inside the SQL. I don't have access to the c# code.</p>