I am trying to replace fields from one table to another. There are 3 records where the condition exists for replacement, however, only one replacement is being done. My table that is being written to has data buffering of 0. Here is the psudo-code:


REPLACE table2.field1 WITH table1.field1, ;
   table2.field2 WITH table1.field2, ;
   table2.field3 WITH table1.field3 ;
   FOR table1.field5 = table2.field5 AND ;
       table1.field6 = table2.field6


It works for one record but the other 2 where the condition "table1.field5 = table2.field5 AND table1.field6 = table2.field6" is true are not being updated. Thanks in advance.