Hello,

Let's make sure I'm following you here. Are you saying you have an existing table structure, which contains all the fields in your SELECT statement, plus some additional ones?

How about:

*-- DUPLICATE ALL DATA INTO A SQL-STATEMENT FOR TRANSFER --*
SELECT a.inv_no,a.part_code,a.part_desc,b.mold_code,b.mat_code,a.part_qty,a.part_cost ;
    FROM order_items a, part_file b ;
    WHERE a.inv_no = cInvoiceNumber AND a.part_code=b.part_code ;
	INTO CURSOR MySqlCursor
select existingTable1  && I'm assume it is already open
append from dbf("mySqlCursor")

This will work as long as the field names are the same. If they are not the same, you can use the AS clause after each field in the SELECT to give each field a different name.

HTH...

>
>1: I tried that, but did not work because I need to use the structure in the other free table
>
>2: Does that not require a lot of memory. Plus it still overwrites the table structure
>
>3. Overwrites the structure.