06-30-2022 03:27 PM
Solved! Go to Solution.
06-30-2022 03:46 PM
LEFT JOIN tblADUsers ON tblADUsers.Userdomain=tblAssets.Userdomain AND tblADUsers.Username=tblAssets.Username
06-30-2022 03:46 PM
LEFT JOIN tblADUsers ON tblADUsers.Userdomain=tblAssets.Userdomain AND tblADUsers.Username=tblAssets.Username
06-30-2022 04:06 PM
RC62N wrote:
If you check the database documentation, you'll see that Userdomain and Username together form the primary key for tblADUsers. To link in tblADUsers, then,LEFT JOIN tblADUsers ON tblADUsers.Userdomain=tblAssets.Userdomain AND tblADUsers.Username=tblAssets.Username
Once you've added tblADUsers to your query you can add the field(s) you need to your report.