Nah still get this 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 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]
Pavel Ivanov-2 wrote: > > 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 > > -- View this message in context: http://www.nabble.com/Subqueries-tp24587437p24589179.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