>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