Left outer joins include all of the records from the first (left) of two tables, even if there are no matching values for records in the second (right) table. Vise versa for a right outer join, and outer join returns a set of records (or rows) that include what an inner join would return but also includes other rows for which no corresponding match is found in the other table