Query Calcs and Group By

edited March 2017 in DADE

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

For reference, I'm using RB16 .

Terry Swiers
Millennium Software, Inc.


  • edited March 2017
    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.

    Best Regards,

    Nico Cizik
    Digital Metaphors
This discussion has been closed.