You cannot do that with just APPEND FROM.

SELECT colB AS colF, colC as colA ;
  FROM tableX ;
  INTO CURSOR crsTemp
SELECT tableY
APPEND FROM ( DBF("crsTemp") )

>
>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?