The difference is simple – in a left outer join, all of
the rows from the “left” table will be displayed, regardless of whether
there are any matching columns in the “right” table. In a right outer
join, all of the rows from the “right” table will be displayed, regardless of whether there are any matching columns in the “left” table.
