>Select table1
>
>Select table2
>Append from table1 for table1.field1 = 1
>
>
>
>Trying to use this command, but it transfers all the records of table1…

APPEND FROM always evaluates the FOR clause as if the record had already been appended, so drop the alias and you should get what you want.

Tamar