Hello everyone, I've been checking archives on this group for hours
and haven't found it yet.

What I want to do seems simple, I'm sure I'm overlooking something
obvious.

I've got one big table, and I want to pull all the records off that
table that have certain words in one of their fields - in other words,
run a set of keywords. The other problem is that I don't want
duplicates.

So let's say PetTable has four records in field "Pets"
1 - dog cat frog
2 - cat dog
3 - bird snake
4 - fish

And KeywordTable has three records in field "Keyword"
1 - dog
2 - cat
3 - fish

What I want to do is search PetTable with the records in KeywordTable.
The result I would want in this case is:
1 - dog cat frog
2 - cat dog
3 - fish

I've been banging my head against the wall with SQL statements like:

SELECT * From PetTable Where Pets = "*" & [KeywordTable].[Keyword] &
"*";

I would appreciate any help you guys can give me!

pinballjim at hotmail dot com