Enum JoinType
Specifies join type.
Namespace: Mediachase.BusinessFoundation.Data.Sql.Management
Assembly: Mediachase.BusinessFoundation.Data.dll
Version: 10.8.0Syntax
public enum JoinTypeFields
| Name | Description |
|---|---|
| CrossJoin | A join whose result set includes one row for each possible pairing of rows from the two tables. |
| FullOuterJoin | All rows in all joined tables are included, whether they are matched or not. |
| Inner | A join that displays only the rows that have a match in both joined tables. |
| 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. |
| 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. |
