Archives of the TeradataForum

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

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

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>>