MySQL Performance: JOIN ON vs WHERE [duplicate]

Here is a good analysis of these two approaches: SQL left join vs multiple tables on FROM line?

This explanation is general, I’m not too sure what MySQL does in this matter; but either way the point is that a JOIN is always more explicit and clear and can be moved from one engine to another with no major changes in the logic of the query.

Leave a Comment

Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)