Operators in joins

Microsoft Query

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.