Archives of the TeradataForum

Message Posted: Fri, 16 Sep 2005 @ 13:40:35 GMT

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

How about some thing like this:

     SELECT
     C1
     ,C2
     ,C3
     FROM TABLEA
     MINUS
     SELECT
     C1
     ,C2
     ,C3
     FROM TABLEB
     ;

I am assuming there is no Null on your fields... If there are, you can use COALESCE to handle them.

Hope this helps!

Mohommod

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