right outer vs left outer join
LEFT OUTER JOIN: is used when retrieving data from multiple tables and will return left table and any matching right table records. RIGHT OUTER JOIN: is used when retrieving data from multiple tables and will return right table and any matching left table records