What SQL statement do I need to take all of the contents of several tables and make a new table.

For instance ... i have a database that has tables for different kinds of school classes... like a table for interent classes and a table for night classes.

how could i create a new table called allclasses that included both the internet and night classes.

i need it to be done in an sql statement

i am using microsoft access 2000.

thanks

You can specify select * into allclasses from nighclasses

select * into allclasses internetclasses.

Not sure if Access lets you run sql statements but you can thru the GUI create new table allclasses and use import wizard to populate the data from two tables.