Re: Missing GROUP BY in query SELECT Max(Alias.field1) as field1, field2 From table

On Jan 17, 7:54 pm, quentin wrote: > Hi AD7six > > Thanks for your answer. > > Yes I've realized my mistake. > Off course it's a sql error and I was wrong when I though that this could > come from the treeBehavior because as you said : "The tree behavior does > not mix max() with other fields" a

Re: Missing GROUP BY in query SELECT Max(Alias.field1) as field1, field2 From table

Hi AD7six Thanks for your answer. Yes I've realized my mistake. Off course it's a sql error and I was wrong when I though that this could come from the treeBehavior because as you said : "The tree behavior does not mix max() with other fields" and the other field come from another behavior tha

Re: Missing GROUP BY in query SELECT Max(Alias.field1) as field1, field2 From table

On Jan 15, 12:29 pm, quentin wrote: > Hi > > I have some strange mysql error when I try to select Max(field1) and > field2. if I select only Max(field1) ( SELECT Max(Alias.field1) as field1 > From table ) it works. > Ok this error probably comes from the mysql version ( ovh server : mysql > clie

Missing GROUP BY in query SELECT Max(Alias.field1) as field1, field2 From table

Hi I have some strange mysql error when I try to select Max(field1) and field2. if I select only Max(field1) ( SELECT Max(Alias.field1) as field1 >From table ) it works. Ok this error probably comes from the mysql version ( ovh server : mysql client Api Version 5.0.32 ) because everything works