SQLite Forum

sql parser error
> I test the sql with mysql ,and I received the right result!
> Why the sql can't run on sqlite,could some one help me?

The syntax of passing a parenthesized multi-column expression to WHERE is apparently a MySQL-ism, not supported by sqlite (at least in this context). Not all SQL runs on all SQL engines.