Hi Kenneth,

The best way to do it is: copy the information you want to an array.
Example:

SELECT .... FROM table1 ;
INTO ARRAY ABC

INSERT INTO table2(....) VALUES (ABC(1), xpto, ABC(3), ...)

This way, you don't have to write directly the fields. Just reference an array with a short name (like this, ABC).

Good luck,

Ricardo