In the diagram they are shown as blue For the matching rows you need to update the rows columns in the target table with values from the source table - Information from www.sqlservertutorial.net