We all knows the difference between a Left and Right Outer Join,
Lets says we have two tables A and B.
A a Left Outer Join B b On (a.id =b.id)

This means all record from table A will be displayed even if there's not a matching record in Table B.

Now if I want a right Outer Join betwee A and B, then instead of using a Right Outer Join I can get the same result using the below query
B b Left Outer Join A a On (b.id =a.id).

So why there's a need of right Outer join, if the same can be achieved using a Left Outer Join?

that's a good question