Archives of the TeradataForum
Message Posted: Mon, 09 Jan 2012 @ 09:25:22 GMT
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..
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|