ora923You are also lacking an alias for subquery (You are utilizing a.Agent_key in outer select clause then A must be an alias from the subquery)This is certainly hardly Everything you meant and is a results of applying (or wanting to use) the aged, historical and out-of-date implicit joins while in the where clause (which you forgot). You ought to