[MySQL] JOIN introduction

Tables for Examples

INNER JOIN

• MySQL JOIN is equal to INNER JOIN.

LEFT JOIN

RIGHT JOIN

FULL JOIN

• MySQL doesn’t support FULL JOIN.
• We can use UNION to combine LEFT JOIN and RIGHT JOIN.