[thelist] SQL Server - INNER JOIN vs WHERE clause

[Scott Dexter]

In SQL Server 2000, the two syntaxes below treated the same when they
are compiled; they result in the same query plan. Other rdbms, I
can't say.


sgd

> 
> 3.
> SELECT table1.foo, table2.bar
> FROM table1
> INNER JOIN table2
> WHERE table1.pkid = table2.fkid
> 
> 4.
> SELECT table1.foo, table2.bar
> FROM table1
> INNER JOIN table2
> ON table1.pkid = table2.fkid
> 
> If you are asking about the differences between syntaxes 3 and 4,
> then according to Rudy Limebeck [0], the two techniques are 
> logically equivalent but can have vastly different performance hits

> depending on how the parser plans the query.  You'll need to 
> consider two key factors when