Class JoinType
Specifies join type.
Inheritance
System.Object
JoinType
Namespace: Mediachase.BusinessFoundation.Data.Sql.Management
Assembly: Mediachase.BusinessFoundation.Data.dll
Version: 14.26.0Syntax
public sealed class JoinType : EnumFields
CrossJoin
A join whose result set includes one row for each possible pairing of rows from the two tables.
Declaration
public const JoinType CrossJoinField Value
| Type | Description |
|---|---|
| JoinType |
FullOuterJoin
All rows in all joined tables are included, whether they are matched or not.
Declaration
public const JoinType FullOuterJoinField Value
| Type | Description |
|---|---|
| JoinType |
Inner
A join that displays only the rows that have a match in both joined tables.
Declaration
public const JoinType InnerField Value
| Type | Description |
|---|---|
| JoinType |
LeftOuter
All rows from the first-named table (the "left" table, which appears leftmost in the JOIN clause) are included. Unmatched rows in the right table do not appear.
Declaration
public const JoinType LeftOuterField Value
| Type | Description |
|---|---|
| JoinType |
RightOuter
All rows in the second-named table (the "right" table, which appears rightmost in the JOIN clause) are included. Unmatched rows in the left table are not included.
Declaration
public const JoinType RightOuterField Value
| Type | Description |
|---|---|
| JoinType |
value__
Declaration
public int value__Field Value
| Type | Description |
|---|---|
| System.Int32 |
