>>What about using

>>Select * from table1;
>>union
>>select * from table2;
>>into table outputtable

>
>Well, I find it more conviniente to use the append because I'm dealing with tables that reside in different paths, and I loop to get to all the paths, and I append through the loop, that way after the loop I should have a joint data table...
>so is there somthing more I should look at in the APPEND FROM command...?
>
>Gadi

---

The problem is that you have different tables with sometimes the same primary keys.
What you can do is setting the index to unique before you append the data
Then you can append all the data
Now you have some duplicate values.
If you only want to have the first ones you can do this.
Set the order off
issue delete all
set the order to the unique index
issue recall all
Now you have only one record per primary key value
now pack the table and set the index to primary key again.

(For changing the index type look at alter table.)