Hubboo <shan...@msn.com> wrote: > Thanks for your reply igor but i get this error > > Likely SQL syntax error: select * from Academic > ?where AcNum = ( > select AcNum from Interest > where AcNum not in (select AcNum from Author) > group by AcNum > order by count(*) desc limit 1 > ); [ near "AcNum": syntax error ] > Exception Name: NS_ERROR_FAILURE > Exception Message: Component returned failure code: 0x80004005 > (NS_ERROR_FAILURE) [mozIStorageConnection.createStatement]
I've actually tested this statement using the database schema you provided, and it worked for me. The statement is syntactically correct. So, either you described your database schema incorrectly, or there's a problem with whatever wrapper you are using to access SQLite. Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users