Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Mon, 08 Feb 2010 @ 14:01:07 GMT


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


Subj:   Error 2801 in an insert query using left outer join
 
From:   Antony Kavin Bosco

Hi All,

I am using an insert query with left outer join condition as below:

     Insert into T2
     Select T1.D,T1.A, T1.B, T1.C
     From T1 Left outer joinT2
     ON
     T1.A=T2.A
     T1.B=T2.B
     T1.C=T2.C
     Where T2.D is null;

Also say,

Table T1 has 100 rows and T2 is empty

T1 has NOT NULL values for A,B,C and D

T1 has primary index with columns A,B and C

T2 has unique primary index with columns A,B and C


Now when I run this query, I get an error as "2801 Duplicate unique prime key error in T2"

Since the target table is empty, I am confused on how I could get a duplication error over there. Kindly help me out.


Thanks in advance,

Antony.



     
  <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