JoinKind.Type

Definition

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.