Only rows matching on both sides. The default, and usually what you want.
Every row from the left, with nulls where the right has no match.
Every row from the right. Equivalent to a Left join with the sides swapped.
Every row from both sides, matched where possible. Not supported by MySQL.
Every combination of both sides. Produces left × right rows — rarely intended.
How two tables are joined.