Add Join

Select Add from the Join menu to display the Add Join dialog box. If the query contains more than one table, Statistica Query automatically creates a join between two tables when it detects a relationship in the original database between two fields in different tables. A join shows how data is related between two tables and determines which cases Statistica Query will "return as data." See the Join Overview for additional details. If you don't see a join line between the two tables and you want to specify a join between fields, you can create a join using this dialog.

Join this table and this field. Select the table in the Join this table drop-down list and the corresponding field in the and this field drop-down list that relates to (joins) a second table and field (see To this table and this field below).

To this table and this field. Select the table in the To this table drop-down list and the corresponding field in the and this field drop-down list that relates to (joins) the first specified table and field (see Join this table and this field above).

With operator. From the With operator drop-down list, select the operator that determines the type of comparison that Statistica Query will perform on the values in the joined fields (see above). You can specify equal to (=), not equal to (<>), greater than (>), greater than or equal to (>=), less than (<), or less than or equal to (<=).

Add. Click the Add button to add the join that you have specified (in the fields described above) to your query. You will then see in the Graphic pane a line connecting the two fields that you have joined with the specified operator in the center of the line.

Close. Click the Close button to close the Add Join dialog box.