Difference in MySQL JOIN vs LEFT JOIN

mysql query-optimization left-join inner-join

I thought that by not specifying a type of join it was assumed to be a LEFT JOIN. Is this not the case?

No, the default join is an INNER JOIN.

Inner join

enter image description here

Left join

enter image description here

mysql query-optimization left-join inner-join

No. When a type isn't specified, an INNER JOIN is used. To read up on differences; wikipedia

mysql query-optimization left-join inner-join

I believe the default is INNER JOIN if you just specify JOIN.

CodeHunter