Archives of the TeradataForum

Message Posted: Thu, 04 Apr 2002 @ 14:03:07 GMT

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

Hi all,

I have a question on join index :

I have two table t1,t2 with the following definition :

CREATE t1( a INTEGER, b INTEGER)PRIMARY INDEX ( a );

and

CREATE t2( a INTEGER, b INTEGER)PRIMARY INDEX ( a );

Now i try creating a join index with the following defintion, why does it fail, what is ambiguous in the definition, i thought the ambiguity of a column could be avoided by qualifying it with a table name, which removes the ambiguity:

create join index ji
as sel (t1.a,t2.b),(t1.b,t2.a) from t1,t2
where t1.a = t2.a;

*** Failure 5464 Error in Join Index DDL, Ambiguous name specified for a join index.

Thanks

Narayan Murthy K S

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