Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Mon, 12 Feb 2007 @ 16:35:46 GMT


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


Subj:   Re: Update with left outer join
 
From:   Nimmala, Meher Tej

Hi,

I hope this might be the one what you are looking for.

     update a
     from tab1 a
     ,(select tb1.col1, tb1.col2, tb2.col1 as b
       from tab1 tb1
       left outer join
       tab2 tb2
       on tb1.col1 = tb2.col1
       ) tmp
     set
     col1 = tmp.col1 (or 9999)
     where tmp.b is null;

Let me know if you have any issues.


Thanks

Meher Tej Nimmala



     
  <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