The result of an SQL join operation that includes the matched rows of two tables that were joined and preserves the unmatched rows of both tables. See also left outer join, right outer join, join.