This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Download Microsoft Edge
More info about Internet Explorer and Microsoft Edge
SQLSTATE: 0A000
Unsupported subquery expression:
ACCESSING_OUTER_QUERY_COLUMN_IS_NOT_ALLOWED
Accessing outer query column is not allowed in this location
<treeNode>
.
AGGREGATE_FUNCTION_MIXED_OUTER_LOCAL_REFERENCES
Found an aggregate function in a correlated predicate that has both outer and local references, which is not supported:
<function>
.
Correlated column is not allowed in a non-equality predicate:
<treeNode>
Correlated column is not allowed in predicate:
<treeNode>
.
A correlated outer name reference within a subquery expression body was not found in the enclosing query:
<value>
.
Expressions referencing the outer query are not supported outside of WHERE/HAVING clauses:
<sqlExprs>
.
LATERAL_JOIN_CONDITION_NON_DETERMINISTIC
Lateral join condition cannot be non-deterministic:
<condition>
.
Correlated scalar subqueries must be aggregated to return at most one row.
A GROUP BY clause in a scalar correlated subquery cannot contain non-correlated columns:
<value>
.
NON_DETERMINISTIC_LATERAL_SUBQUERIES
Non-deterministic lateral subqueries are not supported when joining with outer relations that produce more than one row
<treeNode>
.
Correlated column reference ‘
<expr>
’ cannot be
<dataType>
type.
Correlated scalar subqueries can only be used in filters, aggregations, projections, and UPDATE/MERGE/DELETE commands
<treeNode>
.
UNSUPPORTED_IN_EXISTS_SUBQUERY
IN/EXISTS predicate subqueries can only be used in filters, joins, aggregations, window functions, projections, and UPDATE/MERGE/DELETE commands
<treeNode>
.
