Query must include "THIS" but also one of....

[loydall]

Hello,

I want to be able to query a table so that the results MUST contain a phrase, for example "This is my house" but must also include one or more of the following:

"this is my dog"

or

"this is my cat"

or

"this is my goat"

So, MUST include "This is my house"

and MUST include AT LEAST ONE OF:

"this is my dog"

or

"this is my cat"

or

"this is my goat"

 

[fredericofonseca]

that is a simple and/or type of expression. Show us what you have tried so far, and we will correct any visible error.

Regards

Frederico Fonseca
SysSoft Integrated Ltd

http://www.syssoft-int.com