Can we do a "not in" SQL statement without a derived table?

[Peggy_Beard]

Knowledge Drop

Last tested: Mar 5, 2021

We can do it with merged results! Create the main query and then merge to the query for the "not in" part. The second explore's fields will be null when it's "not in" so you can use a yesno table calculation to find those and remove the ones that aren't null. Keep in mind that this is limited to 5K results on either side of the merge.

This content is subject to limited support.