Archives of the TeradataForum

Message Posted: Thu, 04 Apr 2002 @ 15:16:17 GMT

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

I tried creating the join index by providing an alias for all the columns and it worked. But if i just alias the first column ('t1.a') this is what i get :

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

*** Failure 3515 Duplication of column B in creating a Table, View, Macro or Trigger.

To avoid the ambiguity problem the alias works fine, but the question is why should there be an ambiguity when i have qualified the columns to their respective tables - as "t1.a","t2.a","t1.b","t2.b"?

Narayan Murthy K S

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