>Hi,
>I want to join together data from several identical structure tables.
>I copy the data to a TEMP table, with the copy to command- that works fine.
>I try to copy that data to a central table, before the process I ZAP the table then I issue APPEND FROM TEMP and I get the following ERROR:
>
>>Uniqueness of index ... is violated
>
>I've tryed again this time I eliminated the PRIMARY KEY in the original and target table and now the append finished but I do not have the data copied in three fields, on of them was the former PRIMARY KEY...
>
>Any Ideas?
>
>Gadi
What about using
Select * from table1;
union
select * from table2;
into table outputtable