title: How to insert and pull data out of temporary table using the one SQL Statement
body: <p>I am wondering how I can either use multiple or the same select statement to to insert data into a temporary table and then select data out of the temporary using the same query.</p>
  
  <pre><code>SELECT ADDRESS INTO tempTable FROM LOCATION,
  SELECT AddrFMT([ADDRESS]) AS ADDRESS1 FROM  tempTable;
  </code></pre>
  
  <p>Thanks everyone!</p>