Re: including 'is null' brings cartesian result

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.

WIth that interpretation, the above would give you what he had originally plus a cartesian join of a subset of the rows.

However, it's the sort of thing I would have to experiment with to be sure.

--

This space not for rent.