Find IDs from a list which do not exist in table
As the title says, i'm trying to filter a list of given IDs (could be hundreds) into a list of IDs that do not exist in a table (could have multiple thousands of rows).
My research suggests that I should be doing something like this:
Would you agree and more importantly, can I do this using ORM syntax?
Thanks for any tips or insights you can provide.
1 Reply
i guess not
but this is what i did
which results in this query