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