I have just discovered the INNER LOOP JOIN. I have no idea when to use this feature instead of the regular INNER JOIN. Are there any rules to its use?
If I incorrectly use the INNER LOOP JOIN can it cause me to bring back incorrect data? I am worried about presenting wrong data/ row counts etc.
View Complete Post