Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Mon, 03 Jan 2011 @ 14:21:01 GMT


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


Subj:   Need help on LEFT JOIN - count more than left
 
From:   Chanderbabu_Veppala

Dear Team,

First table conatian 103960 records.

i was joining first table with another table. iam getting extra records in output. My question is why its getting duplicate records in left join.

In extra records am getting same id with some null values, some value related.

Need your help to understand this completely.


Regards

V.Chanderbabu



     
  <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: 27 Dec 2016