Two searches and result showing only what is in first but not second search?

[zaynaly]

I have 2 separate searches.

search1 = 17 results
search2 = 20 results

Key column that exists in both searches is "target_id".

How do I show all results containing the target_id that are in search1 but not in search2? How can I solve this using multisearch, join, or subsearch or is there a better way?

Search 2 acts like a a filter.. I dont want to see any results in search1 that has the key column in search2.

[woodcock · Accepted solution]

Like this:

<search1> AND NOT [ <search2> | stats count BY target_id | table target_id ]