Create a table + populate it using another table in One Query

sql

Solution

try

SELECT column1, column2, ...columnN 
   into first_table_name 
   FROM second_table_name
   [WHERE condition];

first_table_name will have same table column as second table name

Problem

I'm using Access 2000 and I have 2 queries: The first one is: ``` CREATE TABLE first_table_name (....) ``` The second is: ``` INSERT INTO first_table_name [(column1, column2, ... columnN)] SELECT column1, column2, ...columnN FROM second_table_name [WHERE condition]; ``` Is it possible to do the same thing (create a table and immediately fill it using another table) with just one query? Thank you !

Original source