Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 27 Oct 2000 @ 12:50:22 GMT


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


Subj:   Re: Joins
 
From:   Mary Lou Arundell

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
University of Cincinnati



     
  <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