duplicates

This is the SQL view. I noticed that the only employee duplicates are the Companies that have the same Job Classifications. I hope this helps. The table relationship is the Job classification in the JobClass and Employee table.

Thanks,

SELECT DISTINCT [Employees].[EmployeeName], [Employees].[SSNo], [Employees].[Comp], [Employees].[JobClass], [Employees].[PerDiem], [JobClassifications].[StraightRate], [JobClassifications].[OTRate], [JobClassifications].[PerDiemRate], [JobClassifications].[HolidayRate], [JobClassifications].[SundayRate]
FROM JobClassifications INNER JOIN Employees ON [JobClassifications].[Classification]=[Employees].[JobClass]
ORDER BY [Employees].[EmployeeName];

Good Morning Phil,

I get more duplications if I take out the 'DISTINCT' Predicate.

For some reason if I have the Job Class of 'TECHNICIAN' or any other identicle Classification in multiple companies, I get duplications.

I have 809 employees in the 'EMPLOYEE' Table but when I run my employee list query which includes an inner join to Job Class in my 'JobClassification' Table, I get a total of 969 records.

The company name is the Primary Key in the JobClassification Table but I also have an Index for the Job Class, and the Employee Name is the primary key in the Employee table.

I'm not sure if this is causing the conflict with the Indexes.

I also have the Database split, the application is on the user desktop and the tables are on the server.

I really appreciate your help.

Thanks,
Mike

Thank you so much for your time and help!

Mike

You have shed some light. I really appreciate your time and Information. This is very helpful.

Thanks,
Mike