SELECT * FROM tableWithExtraFields INTO CURSOR newCursor APPEND FROM tableWithMissingFieldsThe extra fields will be filled with the default value for that data type.
SELECT * FROM tableWithMissingFields INTO CURSOR newCursor APPEND FROM tableWithExtraFields