On 6/14/2012 2:00 PM, Duquette, William H (318K) wrote:
What I want to do is find a_id's for which c contains no rows with the matching b_id in which the flag column is 1.
Why don't you just say that? select a_id from a where b_id not in (select b_id from c where flag = 1); -- Igor Tandetnik _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
