AnsweredAssumed Answered

Comparing rows from two tables

Question asked by Shraddha on Aug 22, 2010
Latest reply on Aug 23, 2010 by philmodjunk

Title

Comparing rows from two tables

Post

Hi,

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

UNION

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.

Thanks

Outcomes