INNER JOIN & OUTER JOIN

Let's take a simple look!

INNER JOIN

• Intersection based on the key values that are joined

• Does not include Null

OUTER JOIN

• Key set of the reference table based on the key values that are joined

• The reference table includes Null values