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
Finkenstadt [mailto:[EMAIL PROTECTED]
Sent: Friday, June 29, 2007 5:35 PM
To: sqlite-users@sqlite.org
Subject: [sqlite] Multi-column in clause supported?
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
On 6/29/07, Samuel R. Neff [EMAIL PROTECTED] wrote:
You can do it with a JOIN instead of IN and I'm pretty sure it will still
use an index.
SELECT
COUNT(*)
FROM
guid_version_map M
LEFT JOIN
latest_version V
ON
On 6/29/07, Andrew Finkenstadt [EMAIL PROTECTED] wrote:
On 6/29/07, Samuel R. Neff [EMAIL PROTECTED] wrote:
You can do it with a JOIN instead of IN and I'm pretty sure it will
still
use an index.
SELECT
COUNT(*)
FROM
guid_version_map M
LEFT