Answered by:
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?
Friday, September 9, 2016 3:37 PM
Answers
-
- Proposed as answer by Sam ZhaMicrosoft contingent staff Monday, September 12, 2016 5:30 AM
- Marked as answer by AbhishekPandey Saturday, September 17, 2016 4:58 PM
Saturday, September 10, 2016 5:31 PM
All replies
-
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.
Friday, September 9, 2016 3:43 PM -
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]Friday, September 9, 2016 5:43 PM -
Thanks for the link. My point here is how would someone know that which join should i use in a particular condition.Saturday, September 10, 2016 10:51 AM
-
- Proposed as answer by Sam ZhaMicrosoft contingent staff Monday, September 12, 2016 5:30 AM
- Marked as answer by AbhishekPandey Saturday, September 17, 2016 4:58 PM
Saturday, September 10, 2016 5:31 PM