Create joins (optional)

  1. Click the Joins tab.

  2. To create a join, drag your originating column in the primary table to the target column in the secondary table. The join is displayed as a gray line connecting the two columns together. (You may have to scroll to the right to see the selected tables)

  3. You can specify the type of join. Right-click the join and select Specify Join Type. In the Specify Join window, click Inner Join or Left outer join.

  4. You can remove a join. Right-click the join and select Remove Join.

    If the base table is joined with the primary key of another table, the relation is one-to-one and the selected columns are single valued. In other cases, columns are multi-valued. For multi-valued cases, when more than one column in the association table is selected, it is a compound multi-value. The wizard generates a bean for these columns and the multi-value will be an array of this bean. The name of this bean is based upon the display name of the secondary table.



 

Back