cancel
Showing results for 
Search instead for 
Did you mean: 

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

former_member211289
Participant
0 Kudos

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

View Entire Topic
daniele_tiles2
Active Participant
0 Kudos

Hi Ramainadu,

You can try to do like this:

- go to the dfx

- click insert a join

- choose your table

- write the condition with the prompt

- select the cubic for the outer join.

That maybe works, still is kind of weird.

However, your requirement is not clear yet: what are the reporting requirements? Why aren’t you trying to solve by making more queries in WebI?

HTH

Daniele