title: How to do INSERT into a table records extracted from another table
body: <p>I'm trying to write a query that extracts and transforms data from a table and then insert those data into another table. Yes, this is a data warehousing query and I'm doing it in MS Access. So basically I want some query like this:</p>
  
  <pre><code>INSERT INTO Table2(LongIntColumn2, CurrencyColumn2) VALUES
    (SELECT LongIntColumn1, Avg(CurrencyColumn) as CurrencyColumn1 FROM Table1 GROUP BY LongIntColumn1);
  </code></pre>
  
  <p>I tried but get a syntax error message.</p>
  
  <p>What would you do if you want to do this?</p>