Share via


JoinKind.Type

Definition

Specifies the kind of join operation.

Allowed values

Name Value Description
JoinKind.Inner 0 The table resulting from an inner join contains a row for each pair of rows from the specified tables that were determined to match based on the specified key columns.
JoinKind.LeftOuter 1 A left outer join ensures that all rows of the first table appear in the result.
JoinKind.RightOuter 2 A right outer join ensures that all rows of the second table appear in the result.
JoinKind.FullOuter 3 A full outer join ensures that all rows of both tables appear in the result. Rows that did not have a match in the other table are joined with a default row containing null values for all of its columns.
JoinKind.LeftAnti 4 A left anti join returns all rows from the first table that do not have a match in the second table.
JoinKind.RightAnti 5 A right anti join returns all rows from the second table that do not have a match in the first table.
JoinKind.LeftSemi 6 A left semi join returns all rows from the first table that have a match in the second table.
JoinKind.RightSemi 7 A right semi join returns all rows from the second table that have a match in the first table.

Remarks

The fields of this enumeration are possible values for the optional JoinKind parameter in Table.Join.

Applies to