Thanks Jason.
I'm already using joins but the problem I have is it's returning the same record multiple times if more than one keyword matches it. I'm trying to do it so any match returns it but only returns it once.
Can that be done purely by the query with joins or do I need to put some scripting in too?
Cheers
Jon