The result of a join operation that includes the matched rows of both tables that are being joined and preserves the unmatched rows of the second join operand. See also full outer join, left outer join, join.