J Jeff L Aug 25, 2006 #2 It would be an outer join. Here's an example: Select Table1.MyID, Table1.OtherField From Table1 Left Outer Join Table2 On Table1.Id = Table2.ID Click to expand... Where Table2.ID Is Null In this example, the query will give you all records from Table1 that are not in Table2. Hope that helps!
It would be an outer join. Here's an example: Select Table1.MyID, Table1.OtherField From Table1 Left Outer Join Table2 On Table1.Id = Table2.ID Click to expand... Where Table2.ID Is Null In this example, the query will give you all records from Table1 that are not in Table2. Hope that helps!
A Allen Browne Aug 25, 2006 #3 Use the Unmatched query wizard (last option in the first dialog when you create a query.) It's an outer join with Is Null as critiera for the primary key of the related table.
Use the Unmatched query wizard (last option in the first dialog when you create a query.) It's an outer join with Is Null as critiera for the primary key of the related table.
