The above query can't works, because of wrong table name:
tblPersonne.amount_rest
- missed "l".
Try to use
aliases[
^], for example:
SELECT P.EmpKey, P.amount_paid, P.amount_required, P.amount_rest, P.Bus, P.Employee, P.LastName, P.FirstName, P.MiddleName,
P.Shift, P.JobTitle, P.Department,P.HireDate, P.StartDate, P.BirthDate, P.Current, P.WorkStatus, P.Photo,
A.Address1,A.Address2, A.City, A.State, A.ZIP, A.HomePhone, A.WorkPhone, A.CellPager, A.EMail, N.SSN,
D.Gender, D.Race, D.Veteran, D.Handicap
FROM ((tblDepartments RIGHT JOIN ((tblPersonnel AS P LEFT JOIN tblEEOCData AS D ON P.EmpKey = D.EmpKey)
LEFT JOIN tblNumber AS N ON P.EmpKey = N.EmpKey) ON tblDepartments.DeptNo = P.Department)
LEFT JOIN tblAddresses AS A ON P.EmpKey = A.EmpKey)
LEFT JOIN tblPastEmployees ON P.EmpKey = tblPastEmployees.EmpKey;
Finally i have a question: What's this for?
LEFT JOIN tblPastEmployees ON P.EmpKey = tblPastEmployees.EmpKey