MSCEWI3090
Non-Ansi Outer Join has an invalid Between predicate
Last updated
Non-Ansi Outer Join has an invalid Between predicate
Last updated
This is a deprecated version of the SnowConvert documentation, please visit the official site .
Medium
This issue happens when there is an OUTER JOIN with the (+) operator inside a BETWEEN clause that cannot be executed in Snowflake. This generally happens when multiple tables are used in the interval of the BETWEEN clause.
Manually change the Outer Join to ANSI syntax.
If you need more support, you can email us at