Re: [sqlite] Subqueries

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 >>

Re: [sqlite] Subqueries

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 f

Re: [sqlite] Subqueries

ntax error ] Exception Name: NS_ERROR_FAILURE Exception Message: Component returned failure code: 0x80004005 (NS_ERROR_FAILURE) [mozIStorageConnection.createStatement] Igor Tandetnik wrote: > > Hubboo <shan...@msn.com> wrote: >> Q. Among the academics who have no papers, wh

Re: [sqlite] Subqueries

OR_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: >> >> Th

Re: [sqlite] Subqueries

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

Re: [sqlite] Subqueries

Thanks for replying OK we have several tables for our assignment and for this particular question we are asked Q. Among the academics who have no papers, who has the greatest number of interests.. I used the * just return all attributes to start with. When I use SELECT * , count(

[sqlite] Subqueries

Hi, I am doing an assignment using SQLite and was wondering if someone could tell me why this doesn't work and maybe offer some help please? select *, count(distinct 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