Non-equijoins

An equijoin is the most common kind of join condition. It tests whether the two sides of the condition are equal. A non-equijoin uses a comparison operator other than =. You can test if a column from one table contains values that are >, ≥, <, ≤ or < > values in another column.

To create a non-equijoin condition:

1. Define a regular equijoin using the auto join facilities, or by dragging from one column to another.
2. Double click the = operator in the small box on the join line.

   SQLWizard displays the Join Options dialog box.

3. Select a comparison operator from the drop-down list in the center of the dialog box. The operators that contain a + are for defining outer joins.
4. Click OK. The new comparison operator appears in the join condition.

   When the Join Options dialog box closes, the new operator appears on the join line between the joined tables.