Re: [sqlite] Re: Multi-column "in" clause supported?

[Ken]

You can also do: 
   
  select count(*) from guid_version_map
 where guid||version not in (select guid||version from latest_version)
  
 
  Its not exactly the same, typically only good for small results.
  

Igor Tandetnik <[EMAIL PROTECTED]> wrote:
  Andrew Finkenstadt 

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]
-----------------------------------------------------------------------------