Query Calcs and Group By

rbuser

Hi,

Is there any way to prevent the query designer from adding in every single
column in the query into the group by clause when there is a Sum() calc
field?

For reference, I'm using RB16 .

Terry Swiers
Millennium Software, Inc.

nicocizik

Hi Terry,

All columns in the "select" clause that are not an aggregate function
need to be in the "group by" clause. Otherwise you will have an invalid
query and will likely get an error from your DB.

--