MSCEWI1054
Unsupported outer join subquery
Last updated
Unsupported outer join subquery
Last updated
This is a deprecated version of the SnowConvert documentation, please visit the official site .
Low
This error happens when a correlated subquery is found within an OR logical expression of an OUTER JOIN (Left, Right or Full). In those cases they could produce inconsistent results or cause the following error:
SQL compilation error: Unsupported subquery type cannot be evaluated.
These limitations with subqueries are briefly mentioned in and some information about them can also be found in
Verify the output code does not produce a compilation error.
Verify the output code's functional equivalence.
If you need more support, you can email us at