JOIN Types

To get all matching rows from both tables: JOIN

To get all rows from the left table even with no match: JOIN

To get all rows from the right table even with no match: JOIN

A JOIN connects two tables on a common column: ON users.id = orders.