Archives of the TeradataForum

Message Posted: Wed, 21 Jul 2004 @ 12:47:26 GMT

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

Try

     Select * From (select 'hello' As c1) d1
     union
     Select * From (select 'bye-bye' As c1) d2

Regards,

Greg

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