(1) A join method in which a column that is not common to all of the tables being joined becomes part of the resultant table.
(2) The result of a join operation that includes the matched rows of both tables that are being joined and preserves some or all of the unmatched rows of the tables that are being joined. See also inner join, join.