User Guide

10.5.0
- 10.5.3
- 10.4.0
- 10.2.3
- 10.2.2 HotFix 1
- 10.2.2
- 10.2.1
- 10.2

Back Next

Step 6: Specify the Join criteria

If multiple tables were selected, then click the tab labeled Join. The Join page allows you specify the criteria on how the tables should be joined together. Multiple lines of criteria can be entered. Follow the steps below to add Join criteria:

Choose the column (field) to compare on the left side of the join.

Choose the operator (=, >, >=, <, <=, <>) for the join condition.

Choose the type of join:

Inner Join - The results will contain any rows (records) from the two joined tables which match the join condition. All other rows will be excluded from the results.

Left Outer Join - The results will contain all rows from the "left" table, even if the join-condition does not find any matching rows in the "right" table.

Right Outer Join - The results will contain all rows from the "right" table, even if the join-condition does not find any matching rows in the "left" table.

Choose the column (field) to compare on the right side of the join.

If additional lines of Join criteria need to be entered, then specify the conjunction under the AND/OR column and click the

Add Join

link. Repeat steps 1-4 above for the new row of Join criteria.

Additional functions:

Delete a row of Join criteria by selecting its check box and clicking the

Delete Rows

button.

Move a row by selecting it and dragging it up or down.

Use parenthesis to change the order of the Join criteria by entering one or more left parenthesis under the ( column and one or more right parenthesis under the ) column.

Rename Saved Search

Table of Contents

User Guide

User Guide

Step 6: Specify the Join criteria

Step 6: Specify the Join criteria