Creating a table from a query

The method varies according to the DB you are using

Oracle:

create table t_newTable as select * from oldTAble;


mySQL:

create table t_newTable select * from oldTAble;


MSAccess:

SELECT * INTO t_newTable FROM oldTAble;