Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 29 Jul 2008 @ 11:39:22 GMT


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


Subj:   Re: Rows not found during join
 
From:   Sapra, Kapil Dev

Hi,

There is one typo, we can't use "SET t1.consumer_count = ...." and need to use "SET consumer_count = ....".

I think, you need to provide more information (exact sql, tables structure), Not sure but NULL could be one of the reason.


Thanks.

     UPDATE t1
     FROM
            Table1 t1,
            Table2 t2
     SET
            consumer_count = t2.consumer_count
     WHERE
            T1.table1_id = t2.table1_id;

Best Regards,

Kapil Dev Sapra



     
  <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