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

Home -> Community -> Usenet -> comp.databases.theory -> Re: Joins with nulls

Re: Joins with nulls

From: Alfredo Novoa <alfredo_at_ncs.es>
Date: 22 Nov 2002 07:04:54 -0800
Message-ID: <e4330f45.0211220704.1fee137e@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 - 09:04:54 CST

Original text of this message

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