Comparing Access Tables

Question

I have two Access database tables containing place names.

Table A contains 30,000 places and Table B contains 25,000 places.

How can I end up with Table C that only contains the 5,000 places that are in Table A but not in Table B?

Answer 1

In the SQL world, you'd run a SELECT query on the bigger table that outputs all the place names in table A for which a match cannot be found in B - something like:

SELECT     a.placename
FROM       tablea as a
WHERE      NOT EXISTS (SELECT * FROM tableb as b WHERE b.placename = a.placename)

This would form part of a query that puts the results in table c

Not sure if that will help but I have nothing in reach running Access right now! Hopefully there will be an Access guru along in a moment...