Hello,

I have a table X with 10 rows (a,b,c,d...), I need to copy the fields b and c into a temporal file.
I also have another table Y. Quite similar, but the columns are in different oreder.

Then, I need to append fields b and c from the temporal file,
...BUT: I need to place records from temp's clumn b to column f, and temp's column c to column a.

How can I do that using Append from?

Thanks in advance!
Pablo