i'm trying to get a report out with
Table 1
----------
tblAssets.AssetName (Asset Type = 'Mobile Line')
tblAssetCustom.Custom17 as currentuser
tblAssetCustom.Custom19 as currentplan
Table 2
----------
tblAssets.AssetName (Asset Type = 'Cell phone')
tblAssetCustom.Custom17 as phonenumber
I want to merge this 2 table together using table2 assetname as phone assigned. the merging criteria is table1 assetname = table2 phonenumber.
Any help would be appreciated.
Thank you.
