misplacing of on condition in a join was executing successfully instead of throwing a syntax error
This is from Itzik Ben-Gan's book Inside Microsoft SQL Server 2008: T-SQL Querying

I find this explanation (picture including) very helpfull