Operators in joins
You can use the following operators in joins.
| Operator | Description |
|---|---|
| = (Equals) | Selects records that contain equal values in the joined fields. |
| <> (Does not equal) | Selects records that contain values that are not equal in the joined fields. |
| > (Is greater than) | Selects records from the left table that contain values that are greater than values in records from the right table in the joined fields. |
| >= (Is greater than or equal to) | Selects records from the left table that contain values that are greater than or equal to values in records from the right table in the joined fields. |
| < (Is less than) | Selects records from the left table that contain values that are less than values in records from the right table in the joined fields. |
| <= (Is less than or equal to) | Selects records from the left table that contain values that are less than or equal to values in records from the right table in the joined fields. |