In article <[EMAIL PROTECTED]>, "Rob Brooks" <[EMAIL PROTECTED]> writes:
> The only difference in the 2 statements is the 'where items_online.ID = > NULL' part. > Clearly in the first set, items_online.ID = NULL in record 7047 ... Nope. items_online.ID IS NULL for that record, but comparing anything = NULL ain't true, even for NULL. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]