LEFT 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