Something like: SELECT A.ID FROM A LEFT JOIN B ON A.ID = B.ID WHERE B.ID IS NULL
Might be more efficient? -- View this message in context: http://www.nabble.com/WHERE-clause-syntax-error-t1801701.html#a4912687 Sent from the SQLite forum at Nabble.com.
