Page 19 - Unanet AE: Creating Analytic Models Using Query Builder

Join Tables

If at least one table has been added to the Diagram pane, the Tables pane marks in
Bold lettering any tables that have a relationship with any of the recently added tables.

To join the already added table with another table, do one of the following.

• Click the green plus button next to the foreign key column (SupplierID and
CategoryID in the image above).
• Drag and drop the highlighted table from the Tables pane to Diagram pane.
The Query Builder will display a relationship between tables.

LESSON 3: Building Queries In the Analytic Dashboard ©2024 Unanet. All rights reserved. 19
Designer