If you are a visually oriented person, this Venn diagram may help you understand the different types of JOINs that exist within MySQL.
JOIN