This command allows you to specify the join type to be used between files joined in your query.
This command is only available from the Query Window when you have more than one file open at the current level in your query.
When you select the Join Type Options command, the Join Type Options dialog box is displayed. The default Join Type is displayed for each new join. The default is specified by the LANSA Client Administrator as described in Create a LANSA Client Environment in the LANSA Client Administrator's Guide.
From the drop down list, choose the type of join that you require. This can be:
Press the Reset button to reset all joins to the default Join Type.