Active Query Builder  »  User's Guide  »  Building a single query

User's Guide

Joining tables

Index  Previous  Up  Next

Adding and removing joins

When two objects referenced with a foreign key relationship are added to the query, they become joined automatically with INNER JOIN. For those servers that have no support of a JOIN clause, Active Query Builder adds this condition to the WHERE part of the query.

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 the corresponding relationship exists in the database.

Joining tables. Step 1 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 the Delete key.

Changing join type

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

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

Joining tables. Step 3 Link Properties dialog

Index  Previous  Up  Next

News

Tweets

Testimonials

We have been using Active Query Builder for over a year and must say that both the product and support have been outstanding!

We chose Active Query Builder due to its flexibility and features, but have been truly pleased by its power and hidden capabilities. ...

In summary Active Query Builder provides excellent components, great support and a very flexible feature set. It has allowed us to provide features to our end users that I did not think would be possible in the first release of our new tools and in a timeframe that was much shorter than planned. I would recommend that anyone dealing with databases in the .Net world should be aware of this component and its capabilities!


Social networks