8.3.1.7 LEFT JOIN and RIGHT JOIN Optimization - MySQL

2005年1月12日 - The LEFT JOIN condition is used to decide how to retrieve rows from table B . (In other words, any condition in the WHERE clause is not used.).

dev.mysql.com