tiffn

Hello,

Don't ask why but I need to figure out how to use INSERT INTO to copy an entire table into another? I think it is possible but not sure of the syntax or command.

thanks

sandman

If the tables share the same structure (same number of columns, each matching pair of columns with the same datatype), then the syntax is really simple --

insert
into table2
select *
from table1
If the tables do not share the same structure, then you must name the columns of the table you are inserting into, and provide an expression for each of them in the subselect --

insert
into table2
( col1
, col2
, col3 )
select field3
, ( field7 + field8 ) * 9.37
, 0
from table1

INSERT INTO is great because of this ability to reformat data as part of the insertion process.