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")