Full Outer - join NULL value disappear in the where

[Former Member]

Hello,

We have a simple calculation view with FULL Outer join:

When we run the SQL:

SELECT  "XXX"

FROM "_SYS_BIC"."A" ('PLACEHOLDER' = ('$$PD$$', '20160831'))

GROUP BY "XXX"

We get a result of 5 records which one of them is NULL

But when we run the SQL:

SELECT  "XXX"

FROM "_SYS_BIC"."A" ('PLACEHOLDER' = ('$$PD$$', '20160831'))

WHERE "XXX" 'M'

GROUP BY "XXX"

We get a result of 4 records - We don’t get NULL value!!!

Why is that?

(The null record is created because of the full outer join…)

Thanks,

Amir

[gopinath_kolli · Accepted solution]

Hi Amir,

Please follow this blog. This is clearly explained in this.

Thanks,

Gopinath.