What type of Join do I need?

[Commish]

Here's what I am trying to do:

I have a set of records that were imported into an application. And I
have the output from that set of loaded data. However, not all the
records loaded and I'd like to do some type of operation or join to
tell me which records in table A and not present in table B.

That is - if table A had ten values from A-J, and table B had ten
values from F-O, I'd want a join to be able to tell me that values A-E
and not in table B, but are in table A.

Is this possible?

 

[Commish]

Here's what I am trying to do:

I have a set of records that were imported into an application. And I
have the output from that set of loaded data. However, not all the
records loaded and I'd like to do some type of operation or join to
tell me which records in table A and not present in table B.

That is - if table A had ten values from A-J, and table B had ten
values from F-O, I'd want a join to be able to tell me that values A-E
and not in table B, but are in table A.

Is this possible?

OK, I just figured out that if I set the query to filter on criteria
column b IS NULL, then I get the set of records that I am looking for
- in a small test. But... is this the technically correct way to do
this in Access?

 

[John Spencer]

That is one way to do this. There are probably other ways, but this one
is the most efficient.



'====================================================
John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County
'====================================================