On 6/29/07, Igor Tandetnik <[EMAIL PROTECTED]> wrote:
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) ... 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?
Oracle does, but I'm not sure it's part of the SQL89 or SQL92 standards. I found an article that shows its use in Oracle 10gR2 (one of the latest releases), but I know I've been using it for the last 8 to 10 years inside my Oracle databases here, so at least since version 8.0. http://www.devshed.com/c/a/Oracle/Inserting-SubQueries-in-SELECT-Statements-in-Oracle/ --andy