Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: tricky SQL Question
larry.pettit_at_ps.net (Larry Pettit) wrote in
<T5pm4.541$SO4.7493_at_news.uswest.net>:
>
>I want to do a lookup where I get a match based on the number of words
>entered. For example I know that a self join, or subquerry would work but I
>would have to add a level or table for each keyword.
select distinct product from lookup where keyword in ('bat','ball','base')
--
dave mausner
Received on Thu Feb 03 2000 - 20:26:39 CST