GROUP BY function in Avaya CMS

[IndigenousKing]

Hello,

I'm a new user of Avaya CMS. I'm writing a report and I when I check the validity of the query i get the error message stating that the Column is not in GROUP BY. How can I determine what information I should use to group my report so that my query is successsful?

 

[mmxmaverix]

You can use:
(cms)-(root)=# dbaccess (in shell) to test your queries...