Difference in MySQL JOIN vs LEFT JOIN
No. When a type isn't specified, an INNER JOIN
is used. To read up on differences; wikipedia
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.
Here is a visual explanation of SQL joins.
Inner join
Left join