Subject Re: Search strategy
Author Ian A. Newby
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