Show TOC

-1102: Too complicated SQL statement (Too many subqueries)Locate this document in the navigation structure

Use

Explanation

  1. The SQL statement contains too many subqueries. The number of permissible subqueries depends on the kind of SQL statement.

  2. Subqueries were specified in a table expression both in the WHERE clause and in the HAVING clause of an SQL statement containing at least one corresponding subquery. This is not allowed.

User Response

Simplify the SQL statement or split it into several SQL statements.