• The explanation is really simple:

    With the old syntax it's impossible to determine what part of the where statement is used to join the tables and which part is used to filter the records, so the database server has to guess.

    With the proper syntax the part of the join which is used to join the table is after the ON and the part to filter the records is after the WHERE.

    Hope it makes sense,

    Auke