>I have two identical tables and want to either merge them both into a new table, or append from one table to the other table. I have tried INSERT FROM TABLE, but can not get it to work. Also tried INSERT FROM ARRAY, but the two tables have their columns in slightly different order so copying to and from an array will not work.
>
>thanks
>
>Brenda

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