Archives of the TeradataForum

Message Posted: Wed, 12 Sep 2012 @ 10:41:09 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>>