INSERT INTO anotherTable; && comment for a new table SELECT FIELDLIST1 FROM TABLE1; UNION ALL ; && remove ALL for distinct SELECT FIELDLIST2 FROM TABLE2; && INTO TABLE NewTable && uncomment for a new table
SELECT TABLE1 COPY TO NEWTABLE SELECT 0 USE NEWTABLE APPEND FROM TABLE2
INSERT INTO anotherTable; SELECT FIELDLIST FROM oneTable
SELECT anotherTable APPEND FROM oneTable