insert into a table from another table

laals · #1 (**permalink**) 09-16-04, 04:42

hi all..

i'm new in sql and also very poor
i need the sql syntax for inserting into a table from another table both having same structure
pls help

andrewst · #2 (**permalink**) 09-16-04, 07:26

insert into table2 (col1, col2, col3)
select col1, col2, col3 from table1;

If the columns are in the same order in both tables then this shorthand will work:

insert into table2
select * from table1;

laals · #3 (**permalink**) 09-16-04, 08:48

thank u andrews thank u very much
i got it
Lals

Internet Services

Web Development

Digital Marketing

Consumer Tech