To Inner Join or Inner Loop Join, That is the question!

[CodingIsFun]

Hi all experts,

Is there a difference between inner loop join and inner join?

I have come across this inner loop join syntax for the 3rd time and cant resist knowing if there is a special purpose for this.


thanks in advance..

 

[SQLDenis]

Read this:

http://www.sql-server-performance.com/mb_sql_server_joins.asp

Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/

 

[Guru7777]

Here is some information that I think explains it nicely.

http://www.sql-server-performance.com/mb_sql_server_joins.asp

----------------------------------------

TWljcm8kb2Z0J3MgIzEgRmFuIQ==

 

[Guru7777]

DAG! SQLDenis beat me by a minute while I was typing. At least we came up with the same link.

----------------------------------------

TWljcm8kb2Z0J3MgIzEgRmFuIQ==