How to compare columns in different tables and identify values that do not match?

[MsAxes]

Hello all



I have tables with EINs where I need to identify where the Names do not have a partial match. I currently have a query (Test Q) that returns results where the names are at least a partial match. I'm not sure how to identify those that are not a partial match.

If possible, I would like to have a query with a new column where it says "at least a partial match" or "no match".

Thoughts?

[Welshgasman]

Select those that are not in your partial match query?

[Welshgasman]

Double posted in error, as it was still sitting in the reply field, and I thought I had not pressed Post

[MsAxes]

Yeah thought of that too - just not a fan of joining using a name but I will do that and test it out.

Thanks