Sql Excel : JOIN: Combining Two Tables Using a Key Column

The JOIN operator takes two inputs and a join condition as a parameter, and
produces an output that has all the columns in the two tables. The join condition
typically specifies that at least one column in one table is related to one column in
the other, usually by having the same value. This type of join, called an equijoin, is
the most common type of join.
With an equijoin, it is possible to “lose” rows in one or both of the inputs. This
occurs when there is no matching row in the other table. A variation of the join
ensures that all rows in one or the other table are represented in the output.
Specifically, the LEFT OUTER JOIN keeps all rows in the first input table and the
RIGHT OUTER JOIN keeps all rows in the second. FULL OUTER JOIN keeps all
rows in both tables.