Click here to Skip to main content
15,742,973 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Hi friends,
I have a MS Access database and i m working on two tables which include the fields Customer name and Booking date from CustomerMaster and PMReg table.

I want to display only those customer names who are not in PMReg table.
Note: In both table customer names exists.

My query is:
select a.customer from CustomerMaster as c,PMReg as p where
and a.customer not in (select customer from PMReg)
Updated 21-Dec-12 23:23pm

1 solution

you can not use "not in" for access. but you can use joins and check nulls value.
See more detail from here

Finding records that exist in one table but not a query
Share this answer
Maciej Los 15-Apr-13 4:44am    
Good answer, +5!

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900