Archives of the TeradataForum
Message Posted: Wed, 10 Mar 2010 @ 11:22:08 GMT
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.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 23 Jun 2019|