Copy from table to table
Posted: Wed Feb 04, 2004 9:44 am
I need to build a utility that will copy one table to another and reorder it to go into the correct columns on the second table:
ex: table1.column1 ->goes to table2.column13
table1.column2 -> table2.column9
table1.column3 -> table2.column1
and so on......
Is there a function or a tutorial on a way to do this? I have done a copy table to tablenew but this is not the same. Thanks.
mark
ex: table1.column1 ->goes to table2.column13
table1.column2 -> table2.column9
table1.column3 -> table2.column1
and so on......
Is there a function or a tutorial on a way to do this? I have done a copy table to tablenew but this is not the same. Thanks.
mark