O'Reilly logo
  • Dustin Waybright thinks this is interesting:

For many people, though, it’s intuitive to specify the predicate that matches columns from both sides in the ON clause, and predicates that filter columns from only one side in the WHERE clause.


Cover of Training Kit (Exam 70-461): Querying Microsoft® SQL Server® 2012


Even though you could list your predicates in the ON instead of inserting a where clause.