Re: comparing nulls

From: Yong <yhuang_at_slb.com>
Date: 2000/07/26
Message-ID: <8ln5me$ahi$1@news.sinet.slb.com>#1/1

You probably meant:

(t1.a1 = t2.a2 or t1.a1 is null AND t2.a2 is null) and (t1.b1 = t2.b2 or t1.b1 is null AND t2.b2 is null)

Yong

Galen Boyer <galenboyer_at_yahoo.com> wrote in message news:uhf9dzhg9.fsf_at_yahoo.com...

> TRY:
> select count(*) from t1,t1
> where
> (t1.a1 = t2.a2 or t1.a1 is null or t2.a2 is null)
> and (t1.b1 = t2.b2 or t1.b1 is null or t2.b2 is null)
> and ...
>
> --
> Galen Boyer
> Database Architect
> Primix Solutions, www.primix.com
>
>
Received on Wed Jul 26 2000 - 00:00:00 CDT