Re: Joins with nulls
From: Alfredo Novoa <alfredo_at_ncs.es>
Date: 22 Nov 2002 07:04:54 -0800
Message-ID: <e4330f45.0211220704.1fee137e_at_posting.google.com>
Date: 22 Nov 2002 07:04:54 -0800
Message-ID: <e4330f45.0211220704.1fee137e_at_posting.google.com>
Hello
> That's not possible when either of the fields have a null value. You
> cannot say that the null equals any value, and therefore cannot say that
> one null is equal to another null value.
But null is not a value, it is a mark that represents the absence of a value.
If you don't have values you don't have anything to compare.
Alfredo Received on Fri Nov 22 2002 - 16:04:54 CET