Archives of the TeradataForum
Message Posted: Thu, 24 Mar 2005 @ 19:23:41 GMT
Change your Group By to:
Group by pngb.acct_ach_fin_instun.fin_instun_id, pngb.acct_ach_fin_instun.acct_num
You have to group by all the 'selected' columns that are not aggregated.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|