JoinOperator EnumType
the possible values for a join operator in a LinkEntity.
Members
Members define the discrete options for the enumeration type.
| Name | Value | Description |
|---|---|---|
| Inner | 0 | The values in the attributes being joined are compared using a comparison operator. |
| LeftOuter | 1 | All instances of the entity in the FROM clause are returned if they meet WHERE or HAVING search conditions. |
| Natural | 2 | Only one value of the two joined attributes is returned if an equal-join operation is performed and the two values are identical. |
| MatchFirstRowUsingCrossApply | 3 | Link-entity is generated as Correlated Subquery. The outer entity uses the 'cross apply' operator on the Correlated Subquery. Pick the top 1 row. |
| In | 4 | Linked entity translated into Subquery: {LinkToAttribute} in {Select LinkFromAttribute From LinkEntity as Alias} |
| Exists | 5 | Link-entity is generated as a Correlated Subquery. The outer entity uses 'exists' operator on the Correlated Subquery. |
| Any | 6 | Link-entity is generated as Subquery. The outer entity uses the 'in' operator on the Subquery. |
| NotAny | 7 | Generate exists: syntax exists (Select FromAttribute From LinkEntity where LinkEntity.FromAttribute = ToAttribute)) |
| All | 8 | Link entity translated into a SubQuery. The Join is true if link filter conditions are hit for all related entities to a record. |
| NotAll | 9 | Link entity translated into a SubQuery. The Join is true if link filter conditions are hit for only a sub-set (not all) related entities to a record. |
Used by
The following use the JoinOperator EnumType.
| Name | How used |
|---|---|
| LinkEntity | JoinOperator Property |