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.