Re: [sqlite] Unexpected result from SQLite; WebSQL(SQLite) gets it right in sqlfiddle

[Igor Tandetnik]

On 7/11/2013 8:23 AM, Simon Slavin wrote:
and that your entries in whitelist do not have NULL values for whitelist_id.  
Yet your SELECT specifies
       WHERE w.whitelist_id IS NULL

What do you expect to happen here ?  That column can't be null.

The query uses left joins. This condition tests for the case where the 
matching record is not in fact found on the right hand side of such join.
--
Igor Tandetnik

_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users