title: How to INSERT into multiple tables from one SELECT statement
body: <p>I am trying to insert into multiple tables from one select statement.  Is it possible?</p>
  
  <p>Here is what I am trying to do here:</p>
  
  <pre><code>insert into table1 (Name, Address)
  insert into table2 (Name, Address)
  select Name, Address from MainTable
  </code></pre>