Thread: query with COUNT (what am I doing wrong?)
View Single Post

   
  #8 (permalink)  
Old 02-28-2008, 11:29 AM
Captain Paralytic
 
Posts: n/a
Default Re: query with COUNT (what am I doing wrong?)
On 25 Oct, 15:18, panchettone <pan_che_ttone@non_morde.bau> wrote:
> > IIRC, the SQL standard requires that when you mix aggregate functions
> > with columns (or non-aggregate functions) you must GROUP BY all
> > non-aggregate columns or functions.
>
> could you suggest a place online where I can find tips like this one?

The Reference Manual!

http://dev.mysql.com/doc/refman/5.0/en/

Reply With Quote