Linking the Asset and Accounts table

[Ann]

Afternoon All

Please would it be possible for some help with linking two tables together.  I am trying to create a report to show the assets that are assigned to a user.  I am trying to link the tables h_sys_accounts with CMDB Assets, data is being retrieved but the data is repeating itself.  Please would it be possible for some help/guidance on how to link these two tables together properly?  

Kind Regards

Ann

[Steve Giller]

9 minutes ago, Ann said:

I am trying to link the tables h_sys_accounts with CMDB Assets

How are you configuring the JOIN?
There are a number of possible fields you could link to, plus a number of JOIN types.

[Ann]

Afternoon Steve

Thank you.  I am not the best at creating reports so am still learning.

I have tried it with a Left Join and just a join but have been using the field User ID.

Kind Regards

Ann