[概述]

打开查询分析器或SQL Server Managerment Studio中,对需查询账套执行以下语句。

select i.FName as '合同类别',e.Name as '职员',p.Name as '职位',u.FullName as '组织单元',j.Name as '职务',o.OwnerType '拥有者类别' from HM_EM_ContractsType_Owners o

left join HR_Base_Item i on o.ItemID=i.FItemID

left join HM_Employees e on o.OwnerID=e.EM_ID

left join org_position p on o.OwnerID=p.ID

left join org_unit u on o.OwnerID=u.ID

left join org_job j on o.OwnerID=j.ID

order by i.FName