We have two tables, one called 'links' on an external system and one called 'documents' in our Aware app.
Records are added to 'links' periodically and we want to run a process that will copy them over to 'documents'.
The idea is that if the content of 'filepath' from 'links' is not in a record in our 'documents' BO then the record should be copied over.
We have some SQL that shows us how to find those missing records:
Code: Select all
SELECT *
FROM links l
WHERE NOT EXISTS (
SELECT *
FROM documents d
WHERE d.filepath = l.path
}