Hi,
Because "NULL is not a value". Operators [!=] must be suceeded by a value.
These orphans must be selected in a correct way using "is" clause.
Thanks
ViSolve DB Team
- Original Message -
From: "Mufaddal Khumri" <[EMAIL PROTECTED]>
To:
Sent: Thursday, June 14, 2007 1:20 AM
Subje
On Wed, Jun 13, 2007 at 12:50:03PM -0700, Mufaddal Khumri wrote:
> mysql> select * from t1 where sid != 2;
>
> As you can see, the rows that had sid = NULL did not get returned in
> the results when i did "... where sid != ; "
>
> Question: Is this behaviour correct and is in accordance to the
