When modifying an existing query and adding a new subquery, table names now have _# after them. For example, ACTIVITY_2, ACTIVITYCODEDESCRIPTION_2, etc.
Each time a new subquery is added, the table name gets a number added.
When selecting the same table name for the new sub query, there are not any duplicates of the same table in any of the sub queries.
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center