Enum JoinOperatorType

Namespace

YndigoBlue.Velocity.Enums

Assembly

YndigoBlue.Velocity.dll

Specifies the comparison operator used in JOIN conditions.

public enum JoinOperatorType

Fields

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.

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.