Online Documentation for SQL Manager for DB2

Joining two objects


The diagram area allows you to associate two objects by their fields: this operation is performed by dragging a field from one object list to another. This will set a link between these objects by the selected fields. It is indicated by a bidirectional arrow between the linked fields.

 

Note: Once two or more tables related by a foreign key are added to the diagram area, the corresponding visual joining of these tables appears at the Builder tab and the JOIN statement appears under the Edit tab.

 

Query Builder - Joining two objects

 

 

You can view the link properties of objects association: set the mouse cursor over the linking arrow, and a hint containing the association condition will popup after a short delay.

 

To edit the link properties, double-click the linking arrow or right-click it and select the Property popup menu item. The Link properties dialog allows you to change the association condition by choosing it from the drop-down list (=, >, <, >=, <=, <>).

 

Query Builder - Link properties

 

 

For your convenience the CheckBox Include all option is available for each object of the association:

if the option is enabled for the left table, the LEFT JOIN operator will be used for the association;

if the option is enabled for the right table, the RIGHT JOIN operator is used for the association;

if the option is enabled for neither of the tables, the INNER JOIN operator is used for the association.

 

Click OK to apply the changes you have made.
 
To remove a link between objects, right-click the linking arrow and select the Delete link popup menu item.
 
To add a point to the link line, right-click the linking arrow and select the Insert point popup menu item. Using the point you can move the link line easily. The point does not cause any changes to the query, it is only used for the diagram representation and makes visual building handy and more comprehensible.

 

Visual Query Builder - Link menu