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

i'm using access 2000 , have 2 queries:

the first 1 is:

create table first_table_name (....)

the second is:

insert first_table_name [(column1, column2, ... columnn)]     select column1, column2, ...columnn     second_table_name    [where condition];

is possible same thing (create table , fill using table) 1 query?

thank !

try

select column1, column2, ...columnn     first_table_name     second_table_name    [where condition];

first_table_name have same table column second table name

Brande