The Difference Between SQL’s JOIN .. ON Clause and the Where Clause
It does not seem matter at all. Both queries yield the same result as well as the same plan. But in fact, in a INNER JOIN they are same, But on OUTTER JOIN
they are different.
Appears in lists (1)
More like this (3)
The Cost of Useless Surrogate Keys in Relationship Tables — A look at the pros and...