Archives of the TeradataForum

Message Posted: Tue, 06 Sep 2005 @ 18:36:00 GMT

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

Try the following: (keep in mind this produce a product join and may use up a lot of system resource if the list is big)

     Sel a.tablename, b.tablename
     from
      a,
      b
     where
     index(b.column, a.column) > 0
     ;

Samuel Chu




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