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


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