title: Create a table + populate it using another table in One Query
body: <p>I'm using Access 2000 and I have 2 queries:</p>
  
  <p>The first one is: </p>
  
  <pre><code>CREATE TABLE first_table_name (....)
  </code></pre>
  
  <p>The second is:</p>
  
  <pre><code>INSERT INTO first_table_name [(column1, column2, ... columnN)] 
     SELECT column1, column2, ...columnN 
     FROM second_table_name
     [WHERE condition];
  </code></pre>
  
  <p>Is it possible to do the same thing (create a table and immediately fill it using another table) with just one query?</p>
  
  <p>Thank you !</p>