Archives of the TeradataForum

Message Posted: Thu, 24 Mar 2005 @ 19:23:41 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

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.

Mike Dempsey
Teradata Client Tools

	<Prev	Next>		<<First	<Prev	Next>	Last>>