Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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.