Re: copy one table to an other

I think both should have same number of columns

Otherwise supply the required column names as

insert into mytable2(col1, col2...) select col1,col2... from mytable1;

Madhivanan Received on Tue May 10 2005 - 06:58:23 CDT