Archives of the TeradataForum
Message Posted: Mon, 05 May 2008 @ 10:57:15 GMT
Still not able to run this query...
Can't I use the select statement in the 'In' which is in 'when' of 'case' ? like this. --> case when something in select something from some_table) then stmt else stmt end
If I use hardcode values in the place of select statement then it is working but I don't know why It is not working like this..-->case when something in(1000,2000,3000) then stmt else stmt end
Please give me reason why it is so, Or tell me if there is any alternative way to do this.....
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|