Ah it worked actually when i typed it and not pasted. Hubboo wrote: > > 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-tp24587437p24590028.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