Removing a Join for Non-Referenced Records

To modify the simplified analytic query by removing a join if the record is not referenced in select list or under prompts:

1. Join two records such that none of the fields of newly added record are listed in the select list of the query and is not part of the prompt.

   The fields from the second record appears only in the criteria.

2. Add an additional criteria. The existing reports change to reflect the join and the change in criteria.

3. Delete the record from the query. The criteria will automatically be updated to show the changes. The existing report also changes to how they were prior to the join.