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