Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: including 'is null' brings cartesian result

Re: including 'is null' brings cartesian result

From: <mikharakiri_nospaum_at_yahoo.com>
Date: 2 Mar 2005 15:15:16 -0800
Message-ID: <1109805316.402924.21670@f14g2000cwb.googlegroups.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US