Specifications

CHAPTER 3 Managing the Database
Users Guide 107
❖ To join tables:
1 Click the Join button.
2 Click the columns on which you want to join the tables.
In the following screen, the Employee and Department tables are joined on
the dept_id column:
3 To create a join other than the equality join, click the join representation in
the workspace.
The Join dialog box displays:
4 Select the join operator you want from the Join dialog box.
If your DBMS supports outer joins, outer join options also display in the
Join dialog box. For example, in the preceding dialog box (which uses the
Employee and Department tables), you can choose to include rows from
the Employee table where there are no matching departments, or rows
from the Department table where there are no matching employees.
About the Query Governor
You can use the Query Governor to set data selection and retrieval options.
If the Allow Cross Product option is set in the Query Governor, the Join
dialog box displays outer join options. For more information, see “Using
the Query Governor” on page 50.