SELECT Query Difficulties
I'm trying to do a SELECT query to pull up values in one table (tblOne) that do not match any of those in a second table (tblTwo). The first table contains newly imported data with no key (with fields matching those of the database). The second table is a listing of allowable designations, each with a unique key. They are in a text format like this AA/BB, AB/BB, AC/CC, etc. The SQL i've been using is:
SELECT DISTINCT tblOne.Designation
FROM tblOne, tblTwo
I can get a query working that matches records with common designations with no effort at all...but the same can't be said for the opposite (which is what I want). I can't get a query to spit out the records in tblOne with designations that do not match those listed in tblTwo. My goal is to use the query as a tool to list the designations that I need to add to tblTwo. Would anyone mind helping me out on this?