Re: Null in subquery returns no records

From: Mikito Harakiri <mikharakiri_at_iahu.com>
Date: Mon, 9 Feb 2004 18:24:25 -0800
Message-ID: <7qXVb.46$St1.210@news.oracle.com>

"Paul G. Brown" <paul_geoffrey_brown_at_yahoo.com> wrote in message
news:57da7b56.0402091702.5a3fe316_at_posting.google.com... [B]: Codd himself first broached the subject of missing information and

unknown or null values. Now, once you have missing values you've got to

       figure out what to do about them. Eventually it was decided that
       anytime you did anything with a variable whose value was marked
       as "unknown", the result would also be "unknown".

That was the design. The implementation turned out to be

"Anytime you did anything with a variable whose value was marked

as 'unknown', the result would be surprising for the end user". Received on Mon Feb 09 2004 - 20:24:25 CST