ANSI 92 uses INNER JOIN type syntax with the JOIN in the FROM clause, ANSI
89 uses the join in the WHERE clause.
I'd recommend sticking to one standard (ANSI 92), i've seen people mix both
standards, but imho that adds complexity that doesn't need to be there.
Filtering in the ON clause effects OUTER joins, when filtering in the ON
clause the filter is applied before the join basically filtering first and
then join, on the WHERE it is applied after the join.
SQL Server MVP
(Create your own groups, Forum, FAQ's and a ton more)