ora923 rtpYou may also be missing an alias for subquery (You happen to be employing a.Agent_key in outer decide on clause then A have to be an alias in the subquery)This is hardly Everything you supposed and is particularly a results of applying (or trying to use) the aged, historic and outdated implicit joins within the in which clause (which you … Read More