Here is my situation and I believe it may call for some simple SQL, but I
still need help. I have two applications running two different types of
databases (DBase and Paradox). Periodically I need to upate the Paradox
database with any new information that may have been added to the DBase
database. If I read the EmployeeID of both databases into two data
controls, what would be the best way to get the difference between the two
in other words, retrieve a new record set that contains the EmployeeIDs
that are present in the DBase database, but not in the Paradox database)?