INNER JOIN - selects only the common part of the intersection
RIGHT JOIN - common part based on what is on the right + selectable what is on the right.
LEFT JOIN - based on what is on the left, common part and what is on the left. OUTER JOIN - whatever both sides of the table have.
Developer who does not give up and keeps on going.