is right outer join possible to use in real time project.

Question

Hello team in database client server project any project we use inner join and left outer join. almost all situation we use this joins only. but can any one used right outer join? please help me thanks & regards arun

Sundar · Answer

A RIGHT OUTER JOIN is one of the JOIN operations that allow you to specify a JOIN clause. It preserves the unmatched rows from the second (right) table joining them with a NULL in the shape of the first (left) table. A LEFT OUTER JOIN B is equivalent to B RIGHT OUTER JOIN A with the columns in a different order. Using Right Outer Join depends on the requirement. If your application needs or statisfy the above defination then use. else dont use.