Joining virtual objects in the SQL builder

You can use the SQL builder to construct advanced SQL queries and filters to query data from Db2® Database.

Procedure

To join virtual objects in the SQL builder, complete the following steps.

  1. In Data objects, drag any object onto the canvas.
  2. Use the connecting dots to connect the objects together.
  3. On the Configure Join page, click Add join key.
  4. Select one of the following join types:
    • Inner: Only view information that matches in both groups.
    • Left outer: Use when you have a main group and want to add extra details from another group.
    • Right outer: Use when you have a secondary group and want to add extra details from the main group.
    • Full outer: View all the information from both groups.
  5. Click Summary to view all the objects and associated settings.
    • Join: View all the current joins.
    • Select list: Select the columns that you want to display in the SQL result.
    • Filter: Create and add multiple filters.
      Note: If a filter is not available, you can create it with the SQL editor.
  6. Optional: Click Explain the Statement to view a diagram of the query execution plan.
  7. Click Run to run the query.
  8. Optional: Click the Tune function to fine-tune query performance.

What to do next

After you join the tables, you can proceed to publish the joined views to the IBM Knowledge Catalog. For more information, see Publishing virtual data to the catalog in Data Virtualization.