Merging Data

There are four possible ways to join two datasets:

• Inner join (INNER JOIN): Joins data when both have keys.
• Left outer join (LEFT JOIN): Joins when the data on the left side has a key.
• Right outer join (RIGHT JOIN): Joins when the key of the data is on the right side.
• Full outer join (FULL JOIN): Joins when the key exists on either side.