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.