Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Sun, 29 Oct 2000 @ 14:44:42 GMT


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


Subj:   Re: Joins
 
From:   Richard K. Sumner

Tom,

While I'm not sure its THE problem that Teradata is complaining about, I see a problem in the "on" clause of the from statement. The problem is the phrase "AND T3.ATTENTIONTYPE = 'C')". This phrase is a predicate type of phrase rather than a join condition. If you refer to the Teradata RDBMS SQL manual Vol 3, Chapter 17 wherein joins are discussed, you will that a fine line distinction is drawn between join criteria and predicate criteria.

Another way to state the query using a derived table may clarify the issue better:

     "from t1,
     t2,
     t4,
     t5 left outer join (sel "all columns necessary" from table3realname where
     attentiontype = 'c') t3 on t2.beneficiaryid = t3.beneficiaryid"

etc, etc.


Hopefully, this helps,

Rick Sumner



     
  <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: 27 Dec 2016