Table1 >>Field1, Field2, Field3 >>aaaaaa, bbbbbb, cccccc>>
Table2 >>Field1, Field2, Field3 >>dddddd, eeeeee, ffffff>>
Result2 >>Field1, Field2, Field3 >>aaaaaa, bbbbbb, cccccc >>dddddd, eeeeee, ffffff>>
SELECT Field1 ,Field2 ,Field3 FROM Table1; UNION ALL; SELECT Field1 ,Field2 ,Field3 FROM Table2; INTO CURSOR Result2