I have two tables. One table has three fields that may contain the words of another field in another table.
Table A/ Field1 (Description) - Mary had a lamb. Field2 (Action) fast white. Field3 (Accent) - Curly Wool.
Table B/Field (Category) - Lamb belongs to Mary.
How do write a query to return all rows in table A that have 'mary' or 'lamb' in the table B/category field? I used the wildcards '%Mary%' but received numerous erroneous rows.
To do this correctly, I should have one row returned from table A because field 1 (Description) has the words Mary & Lamb although only one word is needed.