record search criteria

I have 2 tables, Hisory and Core Pin History, they both have a field labled ID.  I use that filed to tie the table together for data entry on the same form.  That field is populated in the History table and copied to the Core Pin History table but only if the use enters data in the fields that go with Core Pin History.  If they don't enter data into Core Pin section then no data is entered into the Core Pin history table.  So now i can create a query and link the 2 fields in the query and get records from both tables that have matching ID's but i need to know is how do i get only the records in the history table that have ID's that do not have any matching ID numbers in the Core Pin History table?
LVL 1
AisinAutoAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

TextReportCommented:
You use the LEFT OUTER JOIN with a where like below.
Cheers, Andrew

SELECT H.*
FROM History H LEFT OUTER JOIN [Core Pin History] C ON H.ID = C.ID
WHERE C.ID IS NULL
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.