Right outer join . A right outer join ( or right join ) closely resembles a left outer join , except with the treatment of the tables reversed .
A right outer join works almost like a left outer join , except with how the tables are handled reversed .