assetgroup filter

[zoli]

Hi!

I would filter assetgroup, but I cannot, everything I get all thing.

Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssetCustom.Custom1,
tblAssetCustom.Custom7,
tblAssetCustom.Department,
tblAssetCustom.Custom8,
tblAssetCustom.Branchoffice,
tblAssets.Memory,
tblAssets.NrProcessors,
tblAssets.Processor,
tblAssetGroups.AssetGroup
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype,
tblAssetGroups
Where tblAssetGroups.AssetGroup = 'Monitor'

[zoli]

Thanks, it's okay!

[Hemoco · Accepted solution]

Please use the following query:
Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssetCustom.Custom1,
tblAssetCustom.Custom7,
tblAssetCustom.Department,
tblAssetCustom.Custom8,
tblAssetCustom.Branchoffice,
tblAssets.Memory,
tblAssets.NrProcessors,
tblAssets.Processor,
tblAssetGroups.AssetGroup
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Inner Join tblAssetGroupLink On tblAssets.AssetID = tblAssetGroupLink.AssetID
Inner Join tblAssetGroups On tblAssetGroups.AssetGroupID =
tblAssetGroupLink.AssetGroupID
Where tblAssetGroups.AssetGroup = 'Monitor'