you need to SCAN the table or, if they are not too big and they are same structure
you can do:

SELECT alias1
copy to array aAlias1
SELECT alias2
APPEND FROM ARRAY aAlias1

>hey everyone,
>here is the problem. it is like the previous one i have posted but with a new twist. the first problem was a different angle on trying to solve this one. here is the scenario:
>
>i have to table i have set up as alias.
>alias1 and alias2
>
>i then preceed to excecute the following code:
>select alias1
>insert into alias1 ;
> fields ;
>values alias2->fields
>
>the problem is that i only insert one record into alias1 from alias2 when i want to insert all alias2 records. what am i doing wrong?? any suggestions would be appreciated. thanks.