Changing the Join Criteria of the Query Tables
To modify the simplified analytic query by changing the join criteria of the query:
-
Search and open the required query from the Query Manager.
-
Search and select a record from the Record tab.
-
Click Join Record link to the join with any of the existing records as a Left Outer Join or a Standard Join.
-
Make a change in join criteria for example delete an entity.
-
Save and open an existing simplified analytic report. The report shows the change in join criteria in the query.