mardi 19 mai 2015

ANY operator equivalent in sqlite

Is there 'ANY' operator equivalent in sqlite? SQLite gives an error near ANY operator. Is there any other way to do this in SQlite?

I want to select a set of records which does not equal to any of the records in another set.

For an example,

SELECT EventLogId from EventLog Where EventLog <> ANY (SELECT EventLogId FROM Table2)

Aucun commentaire:

Enregistrer un commentaire