Archives of the TeradataForum

Message Posted: Tue, 28 Sep 2010 @ 22:05:51 GMT

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

Try the following:

     , sum ( CFDW2_iris_tbls.I.nrm_IFG_polcy_5_expos_amt) as field_description1
     , sum ( CFDW2_iris_tbls.I.nrm_IFG_tot_expos_amt) as field_description2
     , sum ( CFDW2_iris_tbls.I.nrm_GEI_polcy_5_expos_amt) as field_description3
     , sum ( CFDW2_iris_tbls.I.nrm_GEI_tot_expos_amt) as field_description4

Joe

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