AnsweredAssumed Answered

Find records from one table that aren't in another

Question asked by Wimmachine on Apr 23, 2010
Latest reply on Apr 26, 2010 by mrvodka

Title

Find records from one table that aren't in another

Post

I am trying to do something fairly simple, but being Friday my concentration level is quite low.. so I need some help.

 

I have 2 tables:  "store" and "import"  which are related by the "ID" field.  "Store" has a single record per ID, "import" can have multiple records with the same ID.  I am trying to find all of the records in the "store" table that are not in the "import" table.

 

Example:

 

Store contains the following IDs:

XX01

XX02

XX03

XX04

 

Import contains:

XX01

XX01

XX01

XX03

 

My desired result:

XX02

XX04

 

What's the best way to achieve this?  My original thought was via a relationship...? Thanks!

Edit:  Forgot to mention using FMP11

Outcomes