Home Page for the TeradataForum
 

Archives of the TeradataForum

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


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


Subj:   Re: Query with NOT IN and quotes
 
From:   Anomy Anom

<-- 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>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 27 Dec 2016