what shall I use : JOIN or INNER JOIN

[ashu_sharma21]

Hi, Please suggest if there is any difference between using keywords JOIN and INNER JOIN? Is there any perfomance advantange in using one of them ? Ashu Sharma Web Analyst

[Anonymous]

JOIN == INNER JOIN. INNER JOIN is implied when using JOIN. No performance difference.

[Colin Angus Mackay]

I use INNER JOIN because it makes my intent clearer to anyone else that has to read the code.

---

Cada uno es artifice de su ventura WDevs.com - Open Source Code Hosting, Blogs, FTP, Mail and Forums

[ashu_sharma21]

Thnx mate ! Ashu

[ashu_sharma21]

I thought similar but was just wondering about the performance. Thanks anyways! Ashu

[Colin Angus Mackay]

If you are worried about performance then use the query analyser and look at the execution plans.

---

Cada uno es artifice de su ventura WDevs.com - Open Source Code Hosting, Blogs, FTP, Mail and Forums