Excluding data if appears in a sub query

[black272]

Hey guys,

Hoping I could get some help with a task that has always proved problematic for me. I want to be able to run a general query (no problem so far). But I also want to remove a large set of IDs from that query if they appeared in a subquery. Typical joins dont seem to work for this. Any advice would be appreciated

[June7]

Maybe like:

SELECT * FROM table1 WHERE NOT ID in (SELECT ID_FK FROM table2 WHERE something)

[Gicu]

You may also consider using NOT EXISTS.
https://www.red-gate.com/hub/product...d-not-subquery
https://answers.microsoft.com/en-us/...1-3dcb711fc9c2
Cheers,