Help with user asset/user relation report

[Sarah_MacG]

Hello,

I'm trying to add a custom user to asset relation to a report I already have.  the custom relation is "Validator"

when I add this, the report only returns assets that have data for this relation type.  I don't want to lose the assets in the report that don't have this relation.  I'd like it to show all the assets and if there is a relation of this type to include it.  Please help!  here is my code attached

[Sarah_MacG · Accepted solution]

figured it out!  had to do a left join and put my relation type criteria in there rather than in the where clause:

Left Join tsysAssetRelationTypes On tblAssetUserRelations.Type =
tsysAssetRelationTypes.RelationTypeID And tsysAssetRelationTypes.name =
'Validator'

This fixed it for me.  🙂