Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 11 Jul 2006 @ 12:29:07 GMT


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


Subj:   Re: Join Index error
 
From:   Victor Sokovin

David, any joy with the JI?

What I have noticed (I did try a few cases in the meantime) is that the parser seems to become more flexible if instead of "LEFT JOIN" I just specify "JOIN". I don't think this will make any difference in your case; you would still get the same JI. Try your original definition with only this modification. I wonder if it works for you like it seems to be working for me.

My first suggestion should probably also do the job but it is such an overkill to have duplicate columns just because of the parser. I thought I should mention this lighter solution.


Regards,

Victor



     
  <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: 15 Jun 2023