Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: including 'is null' brings cartesian result
Malcolm Dew-Jones wrote:
> mikharakiri_nospaum_at_yahoo.com wrote:
> : Apply brackets correctly:
>
> : WHERE (mw.mwv_minimum_wage_variation_id =
> : mwv.minimum_wage_variation_id
> : OR mw.mwv_minimum_wage_variation_id is NULL)
> : AND ...
>
> I wasn't sure about that one.
>
> _Conceptually_ the FROM TABLE1,TABLE2 does a cartesian join which
is
> then filtered by the where clause.
Right. Spotting wrongly placed brackets isn't quite all. One have to look into the expression to make sure that both are join predicates:-) Received on Wed Mar 02 2005 - 17:15:16 CST