无法绑定由多个部分组成的标识符. 如何解决
日期：2014-05-16 浏览次数：20601 次
无法绑定由多个部分组成的标识符.,, 怎么解决啊
------解决方案--------------------
SELECT a.Info_ID
,a.info_Status
,b.status_Name
,a.Info_Regional
,a.Info_ReleaseTime
,a.Info_ContractNO
,a.Info_CustomerName
,a.Info_CustomerContacts
,a.Info_CustomerTel
,a.Info_ContractAmount
,a.Info_ISUserID
,c.Sys_UserName as Info_ISUserName
,a.Info_ISUserDeptID
,c.Sys_Dept as Info_ISUserDept
,a.Info_ISUserDeptGroupID
,c.Sys_DeptGroup as Info_ISUserDeptGroup
,a.Info_MangerUID
,d.Sys_UserName as Info_MangerName
,a.Info_MangerUserDeptID
,d.Sys_Dept as Info_MangerDept
,a.Info_MangerDeptGroupID
,d.Sys_DeptGroup as Info_MangerDeptGroup
,a.Info_OSAssistantUID
,e.Sys_UserName as Info_OSAssistantName
,a.Info_OSAssistantDeptID
,e.Sys_Dept as Info_OSAssistantDept
,a.Info_OSAssistantDeptGroupID
,e.Sys_DeptGroup as Info_OSAssistantDeptGroup
,a.Info_OSUserID
,f.Sys_UserName as Info_OSUserName
,a.Info_OSUserDeptID
,f.Sys_Dept as Info_OSUserDept
,a.Info_OSUserDeptGroupID
,f.Sys_DeptGroup as Info_OSUserDeptGroup
,a.Info_IdentifyingCode
FROM NCC_Info a
inner join NCC_ContractStatus b
on a.info_Status=b.status_ID
left join View_UserMessage c
on a.Info_ISUserID=c.Sys_UserID
left join View_UserMessage d
on a.Info_MangerUID=d.Sys_UserID
left join View_UserMessage e
on a.Info_OSAssistantUID=e.Sys_UserID
left join View_UserMessage f
on a.Info_OSUserID=f.Sys_UserID
------解决方案--------------------
免责声明： 本文仅代表作者个人观点，与爱易网无关。其原创性以及文中陈述文字和内容未经本站证实，对本文以及其中全部或者部分内容、文字的真实性、完整性、及时性本站不作任何保证或承诺，请读者仅作参考，并请自行核实相关内容。
