What Is Right Outer Join

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.

What is difference between left outer join and right outer join?

The key difference between a left outer join, and a right outer join is that in a left outer join it’s the table in the FROM clause whose all rows are returned. Whereas, in a right outer join we are returning all rows from the table specified in the join clause. See you in the next lesson.

When use left join and right join?

LEFT JOINRIGHT JOINIt joins two or more tables, returns all records from the left table, and matching rows from the right-hand table.It is used to join two or more tables, returns all records from the right table, and matching rows from the left-hand table.