摘要： 1.原始查询 SELECT s.Name AS ShiftName, h.BusinessEntityID, d.Name AS DepartmentName FROM HumanResources.EmployeeDepartmentHistory h INNER JOIN HumanResour 阅读全文