Archives of the TeradataForum
Message Posted: Fri, 27 Oct 2000 @ 12:50:22 GMT
The left join between T5 and T3 has the join condition between T2 and T3. Shouldn't that be between T5 and T3?
T5 LEFT JOIN T3 ON (T2.BENEFICIARYID = T3.BENEFICIARYID AND T3.ATTENTIONTYPE = 'C')
Mary Lou Arundell
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|