I am trying to find the fastest way to move data from one table to another. Both tables are almost Identical except the table recieving data has one extra field that has a default value which generate a unique id. Each table contain almost 85 fields or so but for simple example the following table fields have be reduced. Heres what I want to do:

table1 contains data that I want to move
field B
field C
field D


table2 is where I want to recieve the data from table A

field A
field B
field C
field D

how can I move table1 fields B thru D into table2 fields B thru D. In reality I have both table with approx 85 fields and I want to find a way of moving data maybe without defining every single field in table1 in the insert statement. Help appreciate


thank
nick patel