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 a.active=p.active
and a.customer not in (select customer from PMReg)
21 Dec '12 - 23:05
21 Dec '12 - 23:23
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)