On 11/11/2011 9:24 PM, Alexandre Courbot wrote:
Here is a simplified version of the statement I try to run (let a, b,
and m be tables with only one column named c containing integers):
SELECT * FROM m WHERE
c IN (SELECT * FROM a) OR
c IN (SELECT * FROM b)
AND (NOT c IN (SELECT * FROM a)
OR c IN (SELECT * FROM b));
This query doesn't make much sense. It appears that quite a few
conditions are redundant, or else the parentheses are in the wrong
places. What logic were you trying to express here?
--
Igor Tandetnik
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users