SQL Right Join

Right Outer Join will select all rows from right table in the joining condition, no matter if these rows from right table have matching records in the left table. Left table is the one that is straight after SQL from Clause.

Another term for Right Outer Join is right join.

Difference Between Left and Right Join

The main difference between Left and Right join is that, Left join will select all rows from left or first table of joining condition. On the other hand right join will show all rows from right or second table of joining condition.