Join operators in relationships
Join operators are used to specify the type of match between columns that are joined in a relationship.
By default, values are compared by using the equal (=) operator. When you use an operator other than equal (=), you create joins that are based on a range of values.
The join operators are used when you create or edit relationships. The following join operators are supported:
- Equal (=)
- Values in the first and second columns are identical or similar. The values are considered
similar when they have a different data type, accent, or case. For example, the following values are
considered similar:
- Renee, RENEE, and Renée
- String "123" and integer 123
- Less than (<)
- Values in the first column are less than values in the second column.
- Greater than (>)
- Values in the first column are greater than values in the second column.
- Less than or equal (<=)
- Values in the first column are less than or equal to values in the second column.
- Greater than or equal (>=)
- Values in the first column are greater than or equal to values in the second column.
- Less than and greater than (< >)
- Values in the first and second columns are different.
- =N
- Values in the first and second columns are equal, even if both values are null.