The result of a join operation that includes the matched rows of two tables that are being joined and that preserves the unmatched rows of the first table. See also full outer join, right outer join, join.