Re: Inconsistent Query Results
From: <sybrandb_at_yahoo.com>
Date: 25 Jun 2003 00:45:27 -0700
Message-ID: <a1d154f4.0306242345.693024ab_at_posting.google.com>
Date: 25 Jun 2003 00:45:27 -0700
Message-ID: <a1d154f4.0306242345.693024ab_at_posting.google.com>
LKBrwn_DBA <member30625_at_dbforums.com> wrote in message news:<3038469.1056484024_at_dbforums.com>...
> Did you check that OS_NAME is not NULL???
>
> NULLs in any OS_NAME will produce invalid results in your query.
Where did u learn that utter nonsense?
He isn't including NULLs in his query is he?
The records with NULL os_names will be excluded, and also he isn't
asking for them, so nothing wrong.
Sybrand Bakker
Senior Oracle DBA
Received on Wed Jun 25 2003 - 09:45:27 CEST