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 specifiesWHERE w.whitelist_id IS NULLWhat 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 [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
