Changing the Join Criteria of the Query Tables

To modify the simplified analytic query by changing the join criteria of 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 any of the existing records as a Left Outer Join or a Standard Join.

  4. Make a change in join criteria for example delete an entity.

  5. Save and open an existing simplified analytic report. The report shows the change in join criteria in the query.