Left Object

The table on the left of the join. (Read-only)

Right Object

The table on the right of the join. (Read-only)

Select All From Left

Selected, select all matching records from the left table.

Select All From Right

Selected, select all matching records from the right table.

Left Column

The field in the left table to be matched to the Right Column field.

Operator

The condition that the left column must satisfy to return records with the right column. The default is "=" (equal to). See Operator Meanings and Rules below.

Right Column

The field in the right table to be matched to the Left Column field.

Accept (F9)

Accept changes to the join, and close the Link Options.

Cancel (Esc)

Close the Link Options and discard all changes.

Operator Meanings and Rules

Operator

Meaning

Rules

=

Equal to

Enter one or more selection criteria, separated by commas.

==

Equal to (literal)

Enter one or more selection criteria, separated by commas. Treats wildcard characters such as * and ? literally, rather than as wildcards, to allow filtering on fields containing these characters.

<

Less than

Enter a single figure, word or phrase as selection criteria.

<=

Less than or equal to

Enter a single figure, word or phrase as selection criteria.

>

Greater than

Enter a single figure, word or phrase as selection criteria.

>=

Greater than or equal to

Enter a single figure, word or phrase as selection criteria.

<>

Not equal to

Enter one or more selection criteria, separated by commas.

#

Not equal to

Enter one or more selection criteria, separated by commas.

##

Not equal to (literal)

Enter one or more selection criteria, separated by commas. Treats wildcard characters such as * and ? literally, rather than as wildcards, to allow filtering on fields containing these characters.

+-

Equal to plus or minus

For numeric fields, enter one or more selection criteria, separated by commas. Cannot be used with alpha-numeric or date fields.

[]

Inside range

Enter the start and end data for the range, separated by a comma.

][

Outside range

Enter the start and end data for the range, separated by a comma.

*

Containing

Only available if the Field is alphanumeric.

Treats the selection criteria as if there is a * wildcard at each end of each selection entered.

#*

Not containing

Only available if the Field is alphanumeric.

Excludes records that contain the selection criteria from the answer. It treats the selection criteria as if there is a * wildcard at each end of each selection entered and the operator is # or <>.