Archives of the TeradataForum

Message Posted: Thu, 17 Feb 2005 @ 00:30:16 GMT

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

Hi Dieter,

I'm not sure that the statement "...the order of columns may never influence the result set", means that you can mix up the order of the columns in the following query in anyway you like (i.e. ... (a,b) ... select b, a ... !
:-)

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

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

I would expect that if you supplied the columns the "right way around" you would get a different result! As in

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

**Unfortunately** my expectations would not be met. :-(

Glenn Mc

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