Not in query

[toolUser]

Hi,

Just learning FM7.

Situation; two tables in a database with a join on field1. I want to find the records in table1 that are not in table2.

In SQL it might be something like this; SELECT * from table1:Field1 NOT IN table2:field1.

Any ideas?

Thanks,

Jerry

[The Shadow]

FileMaker doesn't support this sort of inter-field query directly. You can add a new calculated field in table1 that has the result (true/false), and then search on that.

Its hard to provide you any specific examples since its not clear how the two tables are related, and what sort of data these fields contain.