JoinKind.Type
Specifies the kind of join operation.
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. |
The fields of this enumeration are possible values for the optional JoinKind
parameter in Table.Join.