Hi Folks,
Please help me on this.
Below is my query.
with x as
(select 'a' as col1 from dual union all
select 'b' as col1 from dual union all
select 'c' as col1 from dual
),
y as
(
select 'b' as col2 from dual union all
select 'c' as col2 from dual union all
select 'd' as col2 from dual union all
select 'e' as col2 from dual
)
select * from x right outer join y
on x.col1=y.col2 and y.col2 is null
Am getting all rows of "COL1" as null. why like this?