Archives of the TeradataForum

Message Posted: Mon, 09 Jan 2012 @ 09:25:22 GMT

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

Dear Sravan,

I hope you need all these columns in select statement. If it is so then you can try out one thing create volatile table with on commit preserve rows and take the data from both tables with below SELECT and filter.

After that you can try out something and if possible do mention the proper primary index as per the data you have.

hope it would resolve your issue..

Vivek

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