Archives of the TeradataForum

Message Posted: Tue, 26 Nov 2002 @ 10:43:25 GMT

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

Hi,

Try this may work out.

select a.col1,b.col2
from a,b
where cast(a.time1 as timestamp(6))=cast(b.time1 as
timestamp(6));

Regards,

Swapnil

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