REPLACE Field1 WITH FieldValue IN Table1 ALL
SELECT One.*, blah, UFDblah, etc ;
   FROM Table1 One, Table2 Two FORCE ;
   INTO CURSOR Appender ;
   WHERE Two.Field2 = One.Field2 AND Two.Field2
SELECT Table3
APPEND FROM DBF("Appender")