Archives of the TeradataForum
Message Posted: Sun, 29 Oct 2000 @ 14:44:42 GMT
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"
Hopefully, this helps,
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|