Archives of the TeradataForum

Message Posted: Wed, 12 Sep 2012 @ 11:57:43 GMT

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

Hi Abhishek,

Try this..

     SELECT
     a.System_Dt Sys_Dt,
     a.Ownership_Desc Ownership_Desc,
     a.Actl_Utilization_Nr Actl,
     a.Vendor_Nr Vendor_Nr
     FROM
     Vendor a
     WHERE
     System_Dt IN ( TIMESTAMP '2012-05-10 00:00:00',TIMESTAMP '2012-05-09 00:00:00' )

Thanks,

Syam.

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