returns all matching rows in both tables, in addition to rows in the left table that have no matching rows in the right ... types of outer joins, the columns in the result row that are from the ...