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