User Guide

Data Files

Specifying join types. If outer joins are supported by your driver, you can specify

either inner joins, left outer joins, or right outer joins. To select the type of join,

double-cli

ck the join line between the fields, and the wizard will display the

Relationship Properties dialog box.

You can also use the icons in the upper right corner of the dialog box to choose

thetypeofj

oin.

Relationship Properties

This dialog box allows you to specify which type of relationship joins your tables.

Figure 3-5

Relationship Properties dialog box

Inner joins. An inner join includes only rows where the related fields are equal.

Complet

ing this would give you a data set that contains the variables ID, REGION,

SALES95,andAV GINC foreachemployeewhoworkedinafixedregion.