USE table1 IN 0 EXCLUSIVE USE table2 IN 0 EXCLUSIVE SELECT * FROM table1 INTO CURSOR crsTemp SELECT table1 ZAP INSERT INTO table1 SELECT * FROM table2 SELECT table2 ZAP INSERT INTO table1 SELECT * FROM crsTemp USE IN table1 USE IN table2 USE IN crsTemp