Best Way To Implement Huge SQL Query In FIleMaker

Questions
26

Sure, sorry about that confusion.

In a typical SQL subquery, you have something like:

select something where some field is not in (select ...).

So, I meant how do I get FileMaker to do this "where some (a specific) field" is not in the outer find?

So far, ...
I have the outer part of the SQL where I get all the records sorted.
I have the inner part where I've restricted the records.

All of the examples I see are were you have a particular value to "omit".

Thanks.