Home Page for the TeradataForum

Archives of the TeradataForum

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

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

Subj:   Re: On Join Index Creation
From:   Narayan Murthy K S

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>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 28 Jun 2020