*-- 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.