New posts in On Clause

How do constant values effect the ON clause of Joins?

SQL JOIN - WHERE clause vs. ON clause