>thanks, but the number of fields(columns) of table1 does not match the number of fields(columns) of table2....
>
>
>Carlos Burgos
Then you may have to list them explicitly, e.g.
insert into Table2 (field1, field2, field3) select ff1, ff2, ff3 from MySecondTable
If it's not broken, fix it until it is.
My Blog