Archives of the TeradataForum
Message Posted: Wed, 14 Jul 2004 @ 15:16:53 GMT
I have 20 case statements to concatinate and i am using the result of one case statement in other. This is the reason i am renaming a case statement. In the query i am renamed the 1st case statement into new_custid, which i am using in the second case statement and so on. The problem is i can not concatinate and rename that column, irrespective of whether i am using case statement or not. For example the following querys is also giving me an error.
select customername NEW_CUST_NAME || custid from customer.
select customername as NEW_CUST_NAME || custid from customer
Both the above queries are not working. Is there a way to get the above querys working. I am renaming the customername to use it down the line.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 23 Jun 2019|