dmanxiii dmanxiii - 2 months ago 6
SQL Question

Explicit vs implicit SQL joins

Is there any efficiency difference in an explicit vs implicit inner join?
For example:

select * from
table a inner join table b
on =;


select a.*, b.*
from table a, table b
where =;


Performance wise, they are exactly the same (at least in SQL Server).

PS: Be aware that the IMPLICIT OUTER JOIN syntax is deprecated since SQL Server 2005. (The IMPLICIT OUTER JOIN syntax as used in the question is still supported)

Deprecation of "Old Style" JOIN Syntax: Only A Partial Thing