Joining a New Record to the Query

To modify the simplified analytic query by joining a new record to the query:

  1. Search and open the required query from the Query Manager.

  2. Search and select a record from the Record tab.

  3. Click Join Record link to the join with the any of the existing records as a Standard Join or Left Outer Join.

  4. Click Add Criteria button on the Auto Join criteria dialog box after selecting all the required criteria for the join.

After the above step, you can modify the queries following any of the methods described below:

  • Add a new field from the newly joined record.

  • Add a criteria involving Fields or Expressions.

  • Add an optional prompt.

  • Add a required prompt.

Add a new field from the newly joined record

After you select the criteria you can select a new field from the Records tab in Fields section. See Adding a New Field From an Existing Record in the Query.

Add a criteria involving fields or expressions

After you select the criteria from the Auto Join criteria dialog box, you can add a new criteria under the Criteria tab and save the query. Open existing reports that reflect the change and show the newly added criteria. See Adding a Criteria Involving the Fields and Expressions.

Adding an optional prompt or a required prompt

After you select the criteria from Auto Join criteria dialog box, add a new prompt from the Prompt tab. See Adding an Optional Prompt.