I have a table with a list of employee records, each identified by a unique id, and there are 9 other fields on the table. There are around 25,000 records. I have to maintain this master table as updates to the records are submitted to me. The structure of the update tables is the same as the master table and between 1 and 9 of the non employee id fields may have changed. Is there a query that can be run to elegantly update the master table? Please see attached for a sample of the master table and update table.