Sergey,

The fields that I listed are the key fields. If they match, I want to combine the records from both tables into a record in the result table. If they don't match, I want to include each record that doesn't match in the new table with the corresponding fields updated in the result table.

Michael E. Harris