Archives of the TeradataForum
Message Posted: Thu, 04 Apr 2002 @ 15:16:17 GMT
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
*** 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
|Copyright 2016 - All Rights Reserved|
|Last Modified: 27 Dec 2016|