Archives of the TeradataForum

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

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

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>>