>two of us were in here talking about this very thing yesterday. i wanted to start using enginebeh = 80 and start changing the sql commands as we redo particular sections of our application because as you say set enginebeh=70 is not a permanent solution. but i could not find an example in the help to fully explain the group by. while i agree that this change removes confusion about the returned data, my problem is this, if i select from one of our transaction tables, maybe 30-50 fields do i have to list each of these fields in the group by? what if i link tables? this may seem like a sill q but i only ask as this would make some/all select statements extremly large and if we change the structure of the table we would have to change all the associateed selects as well.
>Slán

Hi.
You can use a numbered list in the Group By as a half-way solution.