消息：无法绑定 [英] Msg:Could not be bound

问题描述

嘿伙计们，我需要你的帮助。在大多数情况下，下面的Sql工作，但当我添加（DRTM_AssetTracker_Person.Guid，DRTM_AssetTracker_Person.FirstName，DRTM_AssetTracker_Person.LastName）其中（DRTM_AssetTracker_Asset.AssignedPersonID = DRTM_AssetTracker_Person.ID）



进入SQL，它给出了这个错误





Msg 4104，Level 16，State 1，Line 5

多部分标识符DRTM_AssetTracker_Person.ID无法绑定。

消息4104，级别16，状态1，行2

多部分标识符DRTM_AssetTracker_Person.Guid无法绑定。

消息4104，级别16，状态1，行2

多部分标识符DRTM_AssetTracker_Person.FirstName不能绑定。

消息4104，级别16，状态1，行2

无法绑定多部分标识符DRTM_AssetTracker_Person.LastName。



我似乎暂时无法解决问题。 Thanx求助你

Hey guys I need your help. For the most part, the Sql below works, but when I add (DRTM_AssetTracker_Person.Guid,DRTM_AssetTracker_Person.FirstName,DRTM_AssetTracker_Person.LastName) where (DRTM_AssetTracker_Asset.AssignedPersonID = DRTM_AssetTracker_Person.ID)

into the SQL, it gives this error


Msg 4104, Level 16, State 1, Line 5
The multi-part identifier "DRTM_AssetTracker_Person.ID" could not be bound.
Msg 4104, Level 16, State 1, Line 2
The multi-part identifier "DRTM_AssetTracker_Person.Guid" could not be bound.
Msg 4104, Level 16, State 1, Line 2
The multi-part identifier "DRTM_AssetTracker_Person.FirstName" could not be bound.
Msg 4104, Level 16, State 1, Line 2
The multi-part identifier "DRTM_AssetTracker_Person.LastName" could not be bound.

I can't seem to be able to fix the problem for a while now. Thanx for your help

SELECT DRTM_AssetTracker_Asset.ID, DRTM_AssetTracker_Asset.AssetIdentifier, DRTM_AssetTracker_Asset.CreatedOn, DRTM_AssetTracker_Asset.ModifiedOn, DRTM_AssetTracker_Asset.Notes, DRTM_AssetTracker_AssetCondition.Name AS 'Condition', DRTM_AssetTracker_AssetStatus.Name AS 'Status', DRTM_AssetTracker_School.SchoolLocationIdentifier, DRTM_AssetTracker_School.DisplayValue as 'Campus',DRTM_AssetTracker_Manufacturer.Name as 'Manufacturer', DRTM_AssetTracker_Person.Guid, DRTM_AssetTracker_Person.FirstName, DRTM_AssetTracker_Person.LastName

FROM DRTM_AssetTracker.dbo.DRTM_AssetTracker_Asset, DRTM_AssetTracker.dbo.DRTM_AssetTracker_AssetCondition, DRTM_AssetTracker.dbo.DRTM_AssetTracker_AssetStatus, DRTM_AssetTracker.dbo.DRTM_AssetTracker_Manufacturer, DRTM_AssetTracker.dbo.DRTM_AssetTracker_School

WHERE DRTM_AssetTracker_Asset.AssetConditionID = DRTM_AssetTracker_AssetCondition.ID AND DRTM_AssetTracker_Asset.AssetStatusID = DRTM_AssetTracker_AssetStatus.ID AND DRTM_AssetTracker_Asset.SchoolID = DRTM_AssetTracker_School.ID AND DRTM_AssetTracker_Asset.ManufacturerID = DRTM_AssetTracker_Manufacturer.ID AND DRTM_AssetTracker_Asset.AssignedPersonID = DRTM_AssetTracker_Person.ID

推荐答案

你能告诉我吗？你想要的矿石信息，我觉得你有多个表写完 从，Sql server不能允许这类功能，你可以借助于解决问题Sql Join，有关更多信息，请查看此链接什么是'多部分标识符'，为什么不能绑定它？

can you give me more information what you want, I think you have multiple table write after the From, Sql server can't allowed this type of function, you can solve problem with the help of Sql Join, for more information check out this linkWhat is a 'multi-part identifier' and why can't it be bound?

我在FROM子句中添加了（DRTM_AssetTracker_Person.Guid，DRTM_AssetTracker_Person.FirstName，DRTM_AssetTracker_Person.LastName）。

I added (DRTM_AssetTracker_Person.Guid, DRTM_AssetTracker_Person.FirstName, DRTM_AssetTracker_Person.LastName) in the FROM clause.

这篇关于消息：无法绑定的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！