How to select only those rows from a table which don't exist in other table

[Nel]

Hello,



I have two tables with one common field. I want to select only those rows in the first table which values for the common field are different then the values for the common field in the second table.
I have this sql query:

SELECT NOVI.GBR
FROM NOVI
WHERE (((NOVI.GBR)>1080) AND ((Exists (SELECT distinct Avtobusi.Garbr FROM Avtobusi WHERE ( ((Avtobusi.Garbr)>1080)) ))=False));

but I don't get anything as a result.

Can anybody help me please?

Thanks in advance

[JoeM]

Access has a nice Unmatched Query Wizard you can use to do this.
If you work through it and create your query, you can then change the query to SQL view to see what that code looks like.

[Nel]

Thank you very much JoeM