Duplicate entries

[chrisjones]

Afternoon, i have the following querie for a custom report. However this creates duplicates when i run the report. Is there a way i can stop this from happening.

Thanks in advance

Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tsysAssetTypes.AssetTypename,
tsysAssetTypes.AssetTypeIcon10 As icon,
tblOperatingsystem.Caption As [OS name],
tblOperatingsystem.OtherTypeDescription,
tblAssets.Domain,
tblAssets.Memory,
tblAssetCustom.Manufacturer As [Computer Manufacturer],
tblBIOS.Manufacturer As [BIOS manufacturer],
tblBIOS.Caption As BIOS,
tblAssets.Assettype,
tblAssetCustom.Model,
tblAssetCustom.Location,
tblAssets.Firstseen,
tblAssets.Lastseen,
tblAssets.Processor,
tblAssets.Scanserver,
tblAssets.IPAddress,
tblAssetCustom.Department,
tblAssetCustom.Serialnumber,
tblAssetCustom.SystemSKU,
tblADusers.Name,
tblAssetCustom.State
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Inner Join tblOperatingsystem
On tblAssets.AssetID = tblOperatingsystem.AssetID
Inner Join tblBIOS On tblAssets.AssetID = tblBIOS.AssetID
Inner Join tblComputersystem On tblAssets.AssetID = tblComputersystem.AssetID
Inner Join tblADusers On tblAssets.Username = tblADusers.Username
Order By tblAssets.AssetName

[chrisjones]

Excellent thank you

[Susan_A · Accepted solution]

TblADusers and tblAssets are incorrectly linked. This forum topic explains how to correctly link the tables.