Sorry, mis-looked: "as int.AcNumCount" should be "as AcNumCount". Don't see other syntax errors.
Pavel On Tue, Jul 21, 2009 at 10:21 AM, Hubboo<shan...@msn.com> wrote: > > Thanks. Returns an error > > Likely SQL syntax error: select ac.AcNum, count(au.acNum) as auNum, > count(int.acNum) as intNum > from academic ac > LEFT OUTER JOIN author au on ac.AcNum = au.AcNum > LEFT OUTER JOIN interest int on int.AcNum = ac.AcNum > group by ac.AcNum > having count(au.acNum) = 0 > and count(int.acNum) = (select max(acNumCount) from (select count(*) as > int.AcNumCount from interest int group by int.AcNum)) > > [ near " ": syntax error ] > Exception Name: NS_ERROR_FAILURE > Exception Message: Component returned failure code: 0x80004005 > (NS_ERROR_FAILURE) [mozIStorageConnection.createStatement] > > -- > View this message in context: > http://www.nabble.com/Subqueries-tp24587437p24588626.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 > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
