INSERT INTO TableB (field1, field5, field8) ; SELECT field1, field5, field8 FROM TableA>If I have a destination table (DBF) that containes 10 columns and my source table (DBF) has 3 columns, how would I append the 3 source table columns into specific destination columns?
>TableA source table >field1 >field5 >field8 > > >TableB destination table >field1 >field2 >field3 >field4 >field5 >field6 >field7 >field8 >field9 >field10 >>