A join in which records from a table are combined with other records from the same table when there are matching values in the joined fields. A self join can be an inner join or an outer join.