dmanxiii dmanxiii - 1 year ago 89
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 =;

Answer Source

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

Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download