SQL Server Performance Forum – Threads Archive

Joining in SQL Server

Hi I would like to know all the details of joining, better to say basic concepts
of joining with example. so kindly help me. Thanks
Nishant Nishant Kumar

---

Hi Nishant, Basically three types of joins: INNER JOIN, OUTER JOIN & CROSS JOIN
Please have a look into BOL for more information with examples.

---

I wouldn’t call CROSS JOIN a basic type. Along with FULL JOIN, it is a special type, for very specific uses. The INNER JOIN and LEFT JOIN types probably make up 99% of all joined queries. The RIGHT JOIN type is for when you want to list tables in a particular order, but I’ve never heard about a RIGHT JOIN that you could not rewrite as a LEFT JOIN.

---

CROSS JOIN and in SQL Server 2005 CROSS APLLY are considered as join types. BTW, these article series in Crig’s blog tells you eerything you wanted to know about JOINs. http://blogs.msdn.com/craigfr/archive/tags/Joins/default.aspx Roji. P. Thomas
http://toponewithties.blogspot.com

---

Correct, but my point was that it’s not a BASIC type of join that you would use regularly.

---

]]>