如何在ms Access 2010中解决此问题 [英] how to solve this problem in ms access 2010

问题描述

大家好，

在sql语句中，我需要从查询中添加不包含此表单的fildes

Hii everyone,

in sql statement i need to add fildes from query that does not include in this form

SELECT tblPersonnel.EmpKey,tblPersonnel.amount_paid,tblPersonnel.amount_required,tblPersonne.amount_rest,tblPersonnel.Bus,tblPersonnel.Employee, tblPersonnel.LastName, tblPersonnel.FirstName, tblPersonnel.MiddleName, tblPersonnel.Shift, tblPersonnel.JobTitle, tblPersonnel.Department,tblPersonnel.HireDate, tblPersonnel.StartDate, tblPersonnel.BirthDate, tblPersonnel.Current, tblPersonnel.WorkStatus, tblPersonnel.Photo, tblAddresses.Address1,tblAddresses.Address2, tblAddresses.City, tblAddresses.State, tblAddresses.ZIP, tblAddresses.HomePhone, tblAddresses.WorkPhone, tblAddresses.CellPager, tblAddresses.EMail, tblNumber.SSN, tblEEOCData.Gender, tblEEOCData.Race, tblEEOCData.Veteran, tblEEOCData.Handicap FROM ((tblDepartments RIGHT JOIN ((tblPersonnel LEFT JOIN tblEEOCData ON tblPersonnel.EmpKey = tblEEOCData.EmpKey) LEFT JOIN tblNumber ON tblPersonnel.EmpKey = tblNumber.EmpKey) ON tblDepartments.DeptNo = tblPersonnel.Department) LEFT JOIN tblAddresses ON tblPersonnel.EmpKey = tblAddresses.EmpKey) LEFT JOIN tblPastEmployees ON tblPersonnel.EmpKey = tblPastEmployees.EmpKey;

推荐答案

上述查询无法正常工作，因为表名称错误:tblPersonne.amount_rest-缺少"l".

尝试使用别名 [

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

这篇关于如何在ms Access 2010中解决此问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！