Archives of the TeradataForum

Message Posted: Wed, 24 Mar 2004 @ 20:39:55 GMT

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

Hi, all -

I'm getting a syntax error in the following DDL for a simple join index.

CREATE JOIN INDEX j1 AS

SELECT
prod_key,
cust_key,
sum(dw_qty)

FROM cfs_prodata_db.fact_gl_trans_test

WHERE region_key in(1,2,3,4,5,6,7,8)

GROUP BY   prod_key, cust_key ;

The error is:

"Error in join index DDL. Only columns, EXTRACT, SUM, or COUNT expressions are allowed in select list."

The select list DOES contain only those items.

Any ideas?

Thanks in advance.

Jackson

Jackson Price
American Red Cross
Data Warehouse & Decision Support Systems

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