如何查询合同类别权限拥有者?

[概述]

打开查询分析器或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 joi