Ian,

That's an interesting strategy. I'll give it a try, and see how
scalable it is.

Bob M..


At 4/19/2004 09:27 AM, Ian A. Newby wrote:

>Hi Bob,
>
>try,
>
> select
> c.article
> from
> content c
> join keyword k1 on (c.content_id = k1.content_id)
> join keyword k2 on (c.content_id = k2.content_id)
> join keyword k3 on (c.content_id = k3.content_id)
> where
> k1.word = 'firebird' and
> k2.word = 'database' and
> k3.word = 'search'
>
>Regards
> Ian Newby