"无法绑定由多个部分组成的标识符"

[howardpang]

USE AdventureWorks


SELECT HumanResources.Employee.VacationHours,
HumanResources.Employee.LoginID,
HumanResources.Department.Name FROM HumanResources.Employee INNER JOIN
HumanResources.EmployeeDepartmentHistory ON HumanResources.Employee.EmployeeID=
HumanResourses.EmplyeeDepartmentHistory.EmployeeID
INNER JOIN HumanResources.Department ON HumanResourses.EmployeeDepartmentHistory.DepartmentID=
HumanResourses.Department.DepartmentID





无法绑定由多个部分组成的标识符 "HumanResourses.EmplyeeDepartmentHistory.EmployeeID"。
哪位大哥帮帮忙啊,我错在哪里了?先谢谢了

[新鲜鱼排]

不用添加用户名吧，这么长。
SELECT
e.VacationHours,
e.LoginID,
d.Name
FROM HumanResources.Employee e
INNER JOIN HumanResources.EmployeeDepartmentHistory edh
ON e.EmployeeID = edh.EmployeeID
INNER JOIN HumanResources.Department d
ON edh.DepartmentID = d.DepartmentID

[十一月猪]

测试了下 ， 好象并不存在你说的问题

just like:

select master.dbo.sysprocesses.spid
from master.dbo.sysprocesses.spid
where master.dbo.sysprocesses.spid = 1

[shaily]

USE AdventureWorks

SELECT A.VacationHours
,A.LoginID
,C.Name
FROM HumanResources.Employee as A INNER JOIN
HumanResources.EmployeeDepartmentHistory as B ON A.EmployeeID=B.EmployeeID INNER JOIN
HumanResources.Department as C ON B.DepartmentID=C.DepartmentID

一定要写规范，让人易懂，再查找错误。

[shaily]

HumanResourses.EmplyeeDepartmentHistory.EmployeeID 这个语句有问题，应该是无法确定记录