full text query on lookup table

[Erik Rooijmans]

Hi All,

Question here about the following problem:

I have a table books:

ID | Title | Category
----------------------
1 bla Animal
2 blah Animal
3 blahbl Animal

And a table types:

ID |Type |Keyword
-------------------
1 Animal Dog
2 Animal Cat
3 Animal Cow
4 Animal Snake
5 Car Volkswagen
6 Car Mercedes

I would like to have a full text query against animal on the table books that actually need to looks up all the keywords specified in the table types.
So If I would start searching for anmials the full text query would be: select ... where match against ('Dog', 'Cat', (all the animals listed in the type table).
If I would add another animal in the type table this would be used in the next query.

Is there any way to achieve this?

Thanks

Erik