Comparing rows from two tables
I have two spreadsheets that have names of contacts. I need a report that lists the contact (Display Name) that are in one and not in the other.
I have loaded these sheets into two identical tables in FileMaker. If using SQL I could have fired a query against the two tables (A, B):
Select * from A where a.displayname <> b.displayname
Select * from B where B.displayname <> a.displayname
How to accomplish this in filemaker? I am new to this nd any help will be much appreciated.