Help Write Unmatched Query (wizard not working)

[taimysho0]

Hello i tried using the unmatched query wizard but when i get to the screen that shows include like fields, it doesnt display anything even though there are same columns. Can anyone help me write the query instead?



I have two queries:


query 1: has field with ID

Query2: has same field with ID

I want to know what is in Query 1 that is not seen in Query 2. Thanks!

maybe in the "crieteria" section of the ID field in query 1: <>[query2].[id]??

[taimysho0]

nevermind, solved.

SELECT query1.id
FROM query1
LEFT JOIN query2 ON
query1.id = query2.id
WHERE query2.id is NULL;