Archives of the TeradataForum

Message Posted: Fri, 27 Jul 2007 @ 22:40:36 GMT

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

Ooops!

Meant to say, try:

     select a.key_field from   ONE_BIGTABLE a
     MINUS
     select b.key_field from ANOTHER_BIGTABLE b;

Regards,

Terry M. McLeod
Senior Consultant, Professional Services, Retail West
Teradata a Division of NCR

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