I'm attempting to execute this SQL statement ( using SQLiteSpy, if that matters, which is based on 3.3.16 ):
select count(*) from guid_version_map where (guid,version) not in (select guid, version from latest_version) Basically I want to retrieve the rows in guid_version_map whose primary key (guid,version) are not present in some other table. The error reported is a "syntax error near ",", which I assume is where the portion of the "where (guid,version)" tuple gets defined. Does this imply that SQLite does not support the multi-column "in" clause? I can code this up in a procedural way, but I love making the database execute as much stuff as possible, reducing the amount of inter-database interface to my C++ code as possible. --andy
