Home Page for the TeradataForum
 
https:

Archives of the TeradataForum

Message Posted: Tue, 29 Jul 2008 @ 15:07:58 GMT


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


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

Hi,

Till now, I am unable to find any problem in your query and I think that should work.

Could you please provide results of these queries..

SQL-1

     select rpt_member_id, CONSUMER_COUNT from rpt_member
     where rpt_member_id in (326, 387, 427, 448, 469, 488, 509);

SQL-2

     select rpt_member_id, CONSUMER_COUNT from rpt_update_temp
     where rpt_member_id in (326, 387, 427, 448, 469, 488, 509);

SQL-3

     SELECT rpt_member_id
     FROM rpt_member
     WHERE rpt_member_id NOT IN
              (SELECT rpt_member_id FROM rpt_update_temp GROUP BY 1)
       AND CONSUMER_COUNT > 0
     AND rpt_member_id in (326, 387, 427, 448, 469, 488, 509);
     GROUP BY 1
     ;

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: 28 Jun 2020