Re: Left join bug?

Cristian Cudizio wrote:
> besades the fact that i don't know SQL standard i'm a bit confused:
> On 10.2.0.2
> i've :
> SQL> select * from a full outer join b on (1=1);
> NUM NUM
> ---------- ----------
> 1 2
> SQL> select * from a full outer join b on (1=0);
> NUM NUM
> ---------- ----------
> 1
> 2
>
> SQL> select * from a,b;
>
> NUM NUM
> ---------- ----------
> 1 2
>
> Is this correct?

Yes

-- 
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab