find missing records

[frank stone]

Sounds like you need to create an unmatch query. there is
a wizard to do this when you click the new query button.
once created, you can run the unmathched query before you
update table 1.

-----Original Message-----
Hello,
To simplify my question, I'll state it this way. Let's say that I have two tables.

Table 1 contains two fields, SalesRep and RepAlias. In

this table, all the RepAlias fields are blank (null).

Table 2 contains the same two fields. In this table, both fields contain data.

What I want to do is update the RepAlias field in Table 1

with the RepAlias field from Table 2 where the SalesRep
matches. I know how to do this. However, I want to
check to make sure that no SalesReps were not updated (if
they weren't in Table 2).

To do that, I could just run a Select query on Table 1

after the update completes to look for any null RepAlias
fields. However, Table 1 is huge and it takes a long time
to update. I'd rather know ahead of time if there are any
SalesReps in Table 1 that are NOT found in Table 2. That
way I can correct the issue before updating the data.

What's the easiest way to get a list of SalesReps that

exist in Table 1, but don't exist in Table 2?