Re: Null in subquery returns no records

"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 Tue Feb 10 2004 - 03:24:25 CET