Archives of the TeradataForum

Message Posted: Wed, 21 Jul 2004 @ 12:20:20 GMT

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

Victor

Using derived tables can overcome this one. See below:

     select * from (select 'hello' (char(10)) ) t (c1)
     union
     select * from (select 'bye-bye' (char(10))) t (c1) ;

Cheers

Frank

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