Joining tables

Top  Previous  Next

 

Adding and removing joins

 

When two objects referenced with a foreign key relationship are added to the query, they become joined automatically with an INNER JOIN..

 

To create a link between two objects (i.e. join them) manually, you should select the field by which you want to link the object with another and drag it to the corresponding field of the other object. After you finish dragging, a line connecting the linked fields will appear. Key cardinality symbols are placed at the ends of link when corresponding relationship exists in the database.

 

screens - joining tables

Joining tables. Step 1

 

screens - joined tables

Joining tables. Step 2

 

To remove a link between objects, right-click the link line and select the Remove item from the context popup menu or simply press Delete key.

 

Changing join type

 

The join type created by default is INNER JOIN, i.e. only matching records of both tables will be included in the resulting dataset. To change joint type, you may right click the link and choose the join type from "Change type" sub-menu of context popup menu.

 

To define join type and other link properties you may right click the link and select the Properties item from the context popup menu or double-click it to open the Link Properties dialog.

 

screens - link popup menu

Joining tables. Step 3

 

screens - link properties

Link Properties dialog