Behavior
Adds the rows from the right-hand table after the final row of the left-hand table and merges columns of the same name and type.
For every row in the main table, a check is made as to whether there is a row in the right table that has the same values in all key column pairs. These rows are then combined into one row.