Join Operators

There are many different operators that you can choose from when you are specifying a join. The following is a list of the available operators in the Add Join dialog along with their meanings.

Operator Meaning
= Selects records that contain equal values in the joined fields.
<> Selects records that contain values that are not equal in the joined fields.
> Selects records from the first specified table that contain values that are greater than values in records from the second specified table in the joined fields.
>= Selects records from the first specified table that contain values that are greater than or equal to values in records from the second specified table in the joined fields.
< Selects records from the first specified table that contain values that are less than values in records from the second specified table in the joined fields.
<= Selects records from the first specified table that contain values that are less than or equal to values in records from the second specified table in the joined fields.