Help to make a NAV query: That show records from table 1 that does NOT exist in table 2

hummel

hi

Can anybody help on creating this query in NAV?

In SQL it could be either one of 2 queries:

SELECT * FROM Table1
LEFT OUTER JOIN Table2
ON Table1.name = Table2.name
WHERE Table2.id IS NULL

OR

SELECT name, id from Table1 EXCEPT SELECT name,id FROM Table2