Archives of the TeradataForum

Message Posted: Fri, 06 Feb 2009 @ 13:02:33 GMT

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

<-- Anonymously Posted: Fri, 6 Feb 2009 12:39 -->

Hi ,

Please try this. I have tested this small test case . Hope it will resolve the problem.Thanks a lot.

     CT Test_suv( a int , b varchar(200 )) ;

     insert into Test_suv ( 1, ' select * from t1 where c1=10' )

     insert into Test_suv ( 2, ' select * from t1 where c2=''hi'' ' )

     sel * from Test_suv where b in ( ' select * from t1 where c2=''hi'' ' ) ;

Thansk

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