Andrew Finkenstadt <[EMAIL PROTECTED]>
wrote:
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)
Make it
select count(*) from guid_version_map gvm
where not exists (
select * from latest_version lv
where gvm.guid = lv.guid and gvm.version = lv.version
);
Does this imply that SQLite does not support the multi-column "in"
clause?
Yes, SQLite does not support it. Is there a DBMS that does?
Igor Tandetnik
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
