>Hi,
>
>How do you append from one cursor to another with FOR?
>
>I tried:
>

>select C_CURSOR1
>append from DBF("C_CURSOR2") fields FLD1, FLD2 FOR C_CURSOR2.FLD1 = "123"
>

>
>But it appends ALL records from the cursor C_CURSOR2 instead of just the ones matching the FOR
>
>What am I missing?

Why not simply

insert into c_cursor1 (fld1, fld2);
select fdl1, fdl2 from c_cursor2 where fld1='123'