Archives of the TeradataForum

Message Posted: Mon, 05 May 2008 @ 10:57:15 GMT

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

Hi Christian,

Good morning,

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.....

Thanks,

Regards,

Narendra Bhatkande

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