below is the Access 2003 Query, written for find out only those records where the employer name in "Data" Table is not Equal to Emplyer name in "CCM" table. but it not working pls Check & Correct it.

SELECT Data.CUSTOMER_NO, Data.CUSTOMERNAME, CCM.Category, Data.CONSTITUTION, CCM.EMPLOYERNAME, Data.BRANCH_NAME, Data.DECISION_Date
FROM Data, CCM
WHERE (((Data.EMPLOYERNAME)<>[ccm].[employername]))
GROUP BY Data.CUSTOMER_NO, Data.CUSTOMERNAME, CCM.Category, Data.CONSTITUTION, CCM.EMPLOYERNAME, Data.BRANCH_NAME, Data.DECISION_Date
HAVING (((Data.CONSTITUTION)<>"SALARIED CATEGORY C"));