You can specify whether a join is an OUTER or INNER join and set the relation between the tables through the Join properties dialog box. To change join properties from the C1DataView Definition Statement Builder, complete the following steps:

1. Open the C1DataView Definition Statement Builder.
2. Add a Child Table Node.

   When adding the initial table, the Join properties dialog box is not available. Add a child table to the current table for the Join properties dialog box to become available.

3. Click the Add Child Table button to open the Add Child Table dialog box.
4. Select the table you just added from the list of available tables under Select a parent view, or None.
5. Select a related table from the list of available tables under Select a child table to add.
6. Click Add, and Close.
7. Open the Join properties dialog box.
   • If the Tree View is selected, click the connection node between the two tables to view the Joint Properties in the window on the right.
     
   • If the Diagram View is selected, right-click the connection between the two tables and select Properties.
     

     The Join properties dialog box will appear.

     
     
8. From the Join properties dialog box, select an OUTER or INNER join and set the relation between the two selected tables from the Relation drop-down box.

   If a relation is not specified here then it will be automatically detected. A relation must be specified only if related tables have more than one relation between them, because, in this case, the automatically detected relation may not be the relation you want.