AH maybe its something to do with portable firefox Igor Tandetnik wrote: > > 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 > >
-- View this message in context: http://www.nabble.com/Subqueries-tp24587437p24589915.html Sent from the SQLite mailing list archive at Nabble.com. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users