To copy data from table to another table, try the following DQL, replacing text in the square brackets [] with the appropriate table/field names:

For [source table] with [criteria] ;
list records
fields in order.

enter record in [destination table]
[destination field_1] := [source table] [source field_1] ;
[destination field_2] := [source table] [source field_2] .