-7011: Correlated subquery not allowed 

Explanation:

...

       1.      A correlated subquery was used in a <QUERY EXPRESSION> containing at least a UNION, INTERSECT, or EXCEPT. This is not yet allowed.

       2.      A column name was used in a selected column in a scalable subquery; this column name is not known in any FROM clause table.

User Action:

...

       1.      The desired effect can be achieved by splitting the <QUERY statement> into several SQL statements.

       2.      Correct the user name.