Joins the rows of the tables based on the equality of the keys. The results are entered into a new column.