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