New Blog Post: PDF/A and Metadata

Query Calcs and Group By

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

Comments

  • 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
    http://www.digital-metaphors.com
This discussion has been closed.