不用添加用户名吧,这么长。
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
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
from master.dbo.sysprocesses.spid
where master.dbo.sysprocesses.spid = 1
,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 一定要写规范,让人易懂,再查找错误。