Archives of the TeradataForum

Message Posted: Fri, 28 Mar 2008 @ 21:43:41 GMT

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

Try this :

     select dob from emp

     UNION

     SEL TMP2.DT
     FROM
     (SEL DATE - 30) TMP2(DT)

Thx,

Arun.

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