How to Join Columns in the Graphical Query Builder

Move the mouse over a field name (column); when it changes to a hand, click (icon changes to a cross) and drag it to a different object and drop it on the field name (column) you are joining.

A line connects the two columns.

   
Inner and Outer Joins

The default is an inner join and displays with this icon Click to set an inner or outer join, or to delete.

If you want it to be an outer join, click Click to set an inner or outer join, or to delete and select Outer. The (+) opens indicating it is an outer join.

Removing a Join

If you want to remove the join, click Click to set an inner or outer join, or to delete and then click i_xcancel.gif Delete.

Related topics