cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
TRAGAR
Engaged Sweeper II

This Report runs without issue:

Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Username,
tblAssetCustom.Model,
tsysAssetTypes.AssetTypename,
tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssets.Domain,
tblAssets.IPAddress,
tblAssets.Lastseen,
tblAssets.Lasttried
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Where tblAssets.AssetID Not In (Select tblSoftware.AssetID
From tblSoftware Inner Join tblSoftwareUni On tblSoftwareUni.SoftID =
tblSoftware.softID
Where tblSoftwareUni.softwareName Like '%CrowdStrike%') And
tblAssets.AssetName Like 'EW%' And tblAssets.Lastseen <> '' And
tblAssets.Assettype = -1 And tblAssetCustom.State = 1
Order By tblAssets.AssetUnique

I want to add a 'User' column after Username, so I added this after tblAssets.Username:

tblADusers.Displayname As [User],

I receive this error: "The multi-part identifier "tblADusers.Displayname" could not be bound."

What do I need to change to fix this?