title: How to create a table from the results of a SQL query?
body: <p>How can I put the results of a query into a table which is NOT created?</p>
  
  <p>For example, put the following query results into a new table <code>EmployeeDetail</code> which IS NOT CREATED. Create the table and put the results at the same time.</p>
  
  <pre><code>select a.Name, b.Id
  from Database1 a left join 
       Database2 b
  ON a.Id = b.Id
  </code></pre>
  
  <p>How can this be done?</p>