Why do we have Right Join in SQL, if we can use Left Join to get same result as of Right Join by just changing the position of tables?
Most of the people has concern on Right Outer Join. Why it is needed. This is useless, blab blab… The answer is very obvious.
Generally we can exchange the table order if there are only 2 tables involved in JOINS. We can use Left or Right join or we can skip the direction of left and right tables and the output will be same.
But if there are more than two tables involved like 1st table is for Left join and the others 2nd and 3rd table is for Right join then the output will be different and also we cannot switch from right to left and left to right.
For example, We are having 3 tables, from the first two tables we have used INNER JOIN to get the desired result. In the requirement is to get a entire records of a particular column from the 3rd table. In this case RIGHT JOIN is essential.
You may find something interesting on this at below link.