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
>

>
>I need the TableA.field1, TableA.field5, TableA.field8 data to end in the
>TableB.field1, TableB.field5, TableB.field8 columns.
>
>thanks
>nick