Archives of the TeradataForum

Message Posted: Wed, 01 Sep 2004 @ 11:46:27 GMT

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

Hi Karthik

You could try something like this:

     select 1 from TableA
     where TableA.CountCol <> (select count(*) from TableB);

     .IF ACTIVITYCOUNT = 1 THEN .QUIT;

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