Archives of the TeradataForum

Message Posted: Wed, 16 Feb 2005 @ 18:54:22 GMT

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

Dieter Noeth wrote:

     select * from test1
     where (a,b) not in
     (select b,a from test2);

Of course the second select should read:

     select * from test1
     where (b,a) not in
     (select b,a from test2);

But it's still the same answer set:

     *** Query completed. No rows found.
     *** Total elapsed time was 1 second.

Dieter

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