Creating or Modifying Joins
The bottom grid of the Tables/Joins tab shows you the joins in your query.
- New Join allows you to create a new Join. You may wish to use this function rather than dragging between columns on the graphical display.
- you can change the Join Type by selecting from the drop-down list
- to change other aspects of the join, click on Modify
Join Detail window
When you click on New or Modify, you will be shown the Join window.
Using the Join-columns grid
To specify the columns in the join:
- click on the column from the From table
- click on the column from the To table
- as you do so, the columns will be added to the grid
- to add another join column, click on another (empty) row in the grid and repeat the above process
- if there are no more empty rows in the grid, click on Another entry
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.
- 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
- You may also need to compare a join column to a particular value. Example:
Where TabA.MonthlyRevenue > 100000
To do this:
- set the Join Operator to > rather than =
- enter the constant in the Column Function box
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.