which join should be used at which condition

Question

Hello Everyone,

I would like to know how to understand at which condition which type of join should be used. Suppose i have two tables or more. So how would i get to know which type of join should i use?

Answer 1

Try this link for an introduction to joins

http://www.codeproject.com/Tips/712941/Types-of-Join-in-SQL-Server

---

Please click "Mark As Answer" if my post helped. Tony C.

Answer 2

A very nice visualization of the different join types: http://www.codeproject.com/KB/database/Visual_SQL_Joins/Visual_SQL_JOINS_orig.jpg

---

Olaf Helper

[ Blog] [ Xing] [ MVP]

Answer 3

Thanks for the link. My point here is how would someone know that which join should i use in a particular condition.

Answer 4

My point here is how would someone know that which join should i use in a particular condition.

By knowing database design, business logic and the required design; there is no general rule, you have to know the mentioned points.

---

Olaf Helper

[ Blog] [ Xing] [ MVP]