Freigeben über


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

See also