 |
 |
Archives of the TeradataForum
Message Posted: Tue, 05 Apr 2005 @ 22:49:57 GMT
| Subj: | | Re: 3504: selected non-aggregate values must be part of the associated group |
| |
| From: | | Christie, Jon |
Krishna Karra wrote:
| | Can someone tell me what am I doing wrong in the SQL below, and the error that I am getting when I run this sql is "3504:selected no-
aggregate values must be part of the associated group" | |
You need to add pngb.acct_ach_fin_instun.fin_instun_id and pngb.acct_ach_fin_instun.acct_num to your GROUP BY clause.
| |
