asked
Left join and Right join works same but why do we have both?
We have left join and right join in sql server and both works in same way in logical. But why we have both join vailable.? What is the difference in parsing these two joins.? In which case we will prefer right join?When it slow down the query? I expect an excellent way of reply.. Thanking you in anticipation..
Sure thing. Just remember that the site works off of votes. Any question you ask, and any you look at, you should vote good answers up by clicking on the thumbs up next to them. If it's your question, you can also select the best answer by clicking on the check box next to one answer.
Left and right joins are functionally equivalent. There is no difference between them beyond a difference in the application of the syntax. On a right join, all values from the right table are returned and only those values that match on the left. In a left join, all values from the left table are returned and only those values that match on the right. They are just two constructs of the same idea to allow you to logically write your code in a way that makes more sense to you in a given situation. Also, it allows you to quickly modify behavior without having to rearrange your T-SQL code. There is no reason to prefer one over the other. Neither will slow the query or speed the query more than the other.
While a RIGHT JOIN can be constructed to return the same results as a LEFT JOIN, as Grant pointed out, they are different and do not return the same results. You are better off sticking with all LEFT JOINs -- resist the temptation to mix LEFT and RIGHT -- anyone maintaining your code will thank you. If at all possible stick with INNER joins on indexed columns, when your tables get into the millions of rows LEFT joins really drag down performance.
Both right join and left join gives the same result .Then why microsoft has given both?they can have one instead of
two.So there should be some reason to have both.Somebody please correct me if it is wrong
Think of it as syntactic sugar. It gives you more flexibility in how you display the code, which can matter in ease of writing and ease of maintenance.
15 People are following this question.
