Skip to Content
0
Jul 03, 2019 at 11:18 AM

How do we write outer join on single table in snowflake universe?

234 Views

Dear All,

We are facing issues over how to write outer join on single table in snowflake universe.

In detail, We have an object 'X' and in where clause we have the syntax as below in Oracle universe.

Object: X

WHERE Clause: Table1.Column1(+) =@Prompt('Select a Plan Rate Year ','N','Object\Class',MONO,CONSTRAINED)

Query:

How do we write outer join on single table in snowflake universe?

Table1. Column1(+) =@Prompt('Select a Plan Rate Year ','N','Object\Class',MONO,CONSTRAINED)

Although, we have set ANSI92 Parameter to Yes, (+) sign wasn't removed automatically.

Is it like Table1.Column1 RIGHT OUTER JOIN @Prompt('Select a Plan Rate Year ','N','Object\Class',MONO,CONSTRAINED)?

Please do the needful.

Thanks

Ramanaidu