MSCEWI1060
Non-Ansi Outer Join to multiple tables is not supported in Snowflake
Last updated
Non-Ansi Outer Join to multiple tables is not supported in Snowflake
Last updated
This is a deprecated version of the SnowConvert documentation, please visit the official site .
This EWI will be deprecated in the future.
High
Snowflake does not support using the same table on two Non-Ansi Outer Joins.
Rewrite the statement using ANSI Outer Join syntax.
The best way to avoid this EWI would be to rewrite the query, here is the previous example code written using only ANSI outer joins:
Using 'SELECT *
' may affect the order of how the columns are displayed.
Check for unfinished conditionals (AND, …) on the translated code.
If you need more support, you can email us at