Enum JoinOperatorType

Namespace

YndigoBlue.Velocity.Enums

Assembly

YndigoBlue.Velocity.dll

Specifies the comparison operator used in JOIN conditions.

public enum JoinOperatorType

Fields

None = 0

No comparison operator - used for CROSS JOIN which has no ON condition.

Equals = 1

Equality comparison operator (=) for matching rows with equal values.

NotEquals = 2

Inequality comparison operator (!= or <>) for matching rows with different values.

LessThan = 3

Less than comparison operator (<) for matching rows where the left value is smaller.

GreatherThan = 4

Greater than comparison operator (>) for matching rows where the left value is larger.

LessThanOrEqualTo = 5

Less than or equal to comparison operator (<=) for range-based joins.

GreaterThanOrEqualTo = 6

Greater than or equal to comparison operator (>=) for range-based joins.

Function = 7

Function-based join condition where a predicate function determines the join relationship. Used for spatial joins (e.g., ST_Intersects, ST_Contains) and other function-based predicates.

Remarks

JOIN operators define how rows from different tables are matched during a join operation. While equality joins are most common, other operators enable range-based and inequality joins.