Background documentation-7011: Correlated subquery not allowed Locate this document in the navigation structure

 

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 Response

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

  2. Correct the user name.