Append query that checks if value exists before appending

[FoolzRailer]

Hello

I'm trying to run an append query, but it should only append the rows which are not already present.

INSERT INTO NySaneringsData ( DelledningsID, SaneringsmetodeKode )
SELECT SaneringsprojektImport.DelledningsID, SaneringsprojektImport.SaneringsmetodeKode
FROM NySaneringsData RIGHT JOIN SaneringsprojektImport ON NySaneringsData.DelledningsID = SaneringsprojektImport.DelledningsID 
WHERE (((SaneringsprojektImport.SaneringsmetodeKode) Is Not Null) AND ((Exists (SELECT * FROM NySaneringsData WHERE NySaneringsData.SaneringsmetodeKode = SaneringsprojektImport.SaneringsmetodeKode))=False)) 
ORDER BY SaneringsprojektImport.DelledningsID;

I got the above code, which gives the following result: http://imgur.com/kFZZhKb

For some reason not all values are displayed.

Any help would be much appreciated.

[ranman256]

If the table is keyed, adding records will reject duplicates.
If not,
build a query to pull records that DO NOT exist in target and but do in source. (An outer query)
The make it an append query.

[FoolzRailer]

Thanks for the reply!

The table isn't keyed, so I would need to build two queries, in order to do what I want?

[davegri]

Try the NOT Exists, and you won't need the =False

((NOT Exists (SELECT * FROM NySaneringsData WHERE NySaneringsData.SaneringsmetodeKode = SaneringsprojektImport.SaneringsmetodeKode))))

[FoolzRailer]

The below code does the trick

INSERT INTO NySaneringsData ( DelledningsID, SaneringsmetodeKode )
SELECT SaneringsprojektImport.DelledningsID, SaneringsprojektImport.SaneringsmetodeKode
FROM SaneringsprojektImport
WHERE (((SaneringsprojektImport.SaneringsmetodeKode) Is Not Null) AND ((Exists (SELECT * 
FROM NySaneringsData 
WHERE NySaneringsData.SaneringsmetodeKode = SaneringsprojektImport.SaneringsmetodeKode
AND NySaneringsData.DelledningsID = SaneringsprojektImport.DelledningsID
))=False));