Archives of the TeradataForum

Message Posted: Tue, 20 Apr 2004 @ 20:07:13 GMT

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

Taking the risk of saying something simple, I would just suggest for your example

     select a1
     from test01
     where a2=1 ;

Hope this helps.

Victor

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