Join operators
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 following join operators are supported:
- Equal (=)
- Values in the left and right 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 left column are less than values in the right column.
- Greater than (>)
- Values in the left column are greater than values in the right column.
- Less than or equal (<=)
- Values in the left column are less than or equal to values in the right column.
- Greater than or equal (>=)
- Values in the left column are greater than or equal to values in the right column.
- Less than and greater than (< >)
- Values in the left and right columns are different.
- =N
- Values in the left and right columns are equal, even if both values are null.
The join operators are used when creating or editing relationships. For more information, see Creating a relationship.