Re: SQL: partial match with set of vsalues from a subquery

I hope i've undestood your problem.

The solution may be:

select a.code,b.name from tabA a,tabB b

   where a.code=b.code and (a.patternhere

      IN ( select pattern from tabC c where c.pattern like '%I am in%')

          or a.patternhere like '%I am in%')

Is it what you expect? Received on Tue Aug 09 2005 - 06:58:45 CDT