Define Relation

     This UI helps to link the tables chosen for the query, as required.

• Click link “Define Relation” in   build relationship – build query screen.

Take help on the “Base Table Field” to select a column from base table, for joining appropriately with the other participating tables.

• Select the “Join Type” as required

Take help on the “Related Table Field” to select a column from participating table for joining with the base table.

• Click “Save” and click “back”.