Previous Topic

Next Topic

Book Contents

Book Index

Creating or Modifying Joins

The bottom grid of the Tables/Joins tab shows you the joins in your query.

query_builder_join1

Join Detail window

When you click on New or Modify, you will be shown the Join window.

query_builder_join2

Using the Join-columns grid

To specify the columns in the join:

Auto Join

This can be a quick way of setting the join columns. If the columns you are joining have the same name in both tables, Auto Join will automatically add them to the join grid.

Join Expression

This panel allows you to specify some "advanced" join options.

  1. Sometimes you may wish to use a column function with your join columns. Example:

    Where UCase(TabA.CustCode) = UCase(TabB.CustCode)

    This can be done by using the Column Function drop-down boxes, or entering a column function

  2. You may also need to compare a join column to a particular value. Example:

    Where TabA.MonthlyRevenue > 100000

    To do this:

Remember Join

Once you have defined the join as required, you can click on Remember Join for AQT to save the details of the join.

This will be saved as a User-Defined Relationship.