Archives of the TeradataForum

Message Posted: Wed, 10 Mar 2010 @ 11:22:08 GMT

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

Another same error for the below join index -

     CREATE JOIN INDEX WOFDWRPT.D_CUST_CSTM_SCOR_MV_JI AS SELECT B.CUST_CSTM_SCOR_RNGE,
     B.CUST_CSTM_SCOR ,TRIM(cast (B.CUST_CSTM_SCOR as CHAR(10))) CUST_CSTM_SCOR_DESC
                FROM wofdwrpt.F_BRU B group by 1,2,3;

     5464: Error in Join Index DDL, Only Column, Extract, SUM or COUNT expression
           with aliases are allowed in select list

Any help would be really appreciated.

Thanks,

Syed

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