JoinOperator JoinOperator JoinOperator JoinOperator Enum

Definition

Contains the possible values for a join operator in a LinkEntity.

public enum class JoinOperator
[System.Runtime.Serialization.DataContract(Name="JoinOperator", Namespace="http://schemas.microsoft.com/xrm/2011/Contracts")]
public enum JoinOperator
type JoinOperator = 
Public Enum JoinOperator
Inheritance
JoinOperatorJoinOperatorJoinOperatorJoinOperator
Attributes

Fields

All All All All 8
Any Any Any Any 6
Exists Exists Exists Exists 5
In In In In 4
Inner Inner Inner Inner 0

The values in the attributes being joined are compared using a comparison operator. Value = 0.

LeftOuter LeftOuter LeftOuter LeftOuter 1

All instances of the entity in the FROM clause are returned if they meet WHERE or HAVING search conditions. Value = 1.

MatchFirstRowUsingCrossApply MatchFirstRowUsingCrossApply MatchFirstRowUsingCrossApply MatchFirstRowUsingCrossApply 3
Natural Natural Natural 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. Value = 2.

NotAll NotAll NotAll NotAll 9
NotAny NotAny NotAny NotAny 7

Applies to