Select where not like query (1 Viewer)

[dougmcc1]

Hi,

I'm trying to create a query that will return strings from one table that don't contain certain words which are located in another table. So I have two tables. One table has a list of strings, and the other table has a list of words. I want the query to return all strings from table A that don't contain any of the words in table B.

I'm guessing the SQl will look something like this:
SELECT string FROM tableA WHERE string NOT LIKE " *words_in_tableB* ";

Thanks.

 

[ByteMyzer]

Assuming the following table structures:
TableA
-StringField

TableB
-WordField

Try the following:

SELECT TableA.*
FROM TableA
WHERE NOT EXISTS (
    SELECT TableB.*
    FROM TableB
    WHERE TableA.StringField Like '*' & TableB.WordField & '*';
);

 

[Mile-O]

Alternatively, use the Find Duplicates Query Wizard and, once the query has been made, reverse the criteria.