Assets Report SELECT TOP 100 PERCENT dbo.tbl_VersaAssets.AssetDisplayID, dbo.tbl_VersaAssetTypes.AssetType, dbo.tbl_VersaAssets.FirstName + ' ' + dbo.tbl_VersaAssets.Surname AS Expr1, dbo.tbl_VersaAssets.BLocation, dbo.tbl_VersaAssets.BOrg2, dbo.tbl_VersaAssets.BLocation, dbo.tbl_VersaAssets.BOrg1 FROM dbo.tbl_VersaAssets LEFT OUTER JOIN dbo.tbl_VersaAssetTypes ON dbo.tbl_VersaAssets.AssetTypeID = dbo.tbl_VersaAssetTypes.AssetTypeID ORDER BY dbo.tbl_VersaAssets.AssetDisplayID Asset ID Asset Type Allocated To Location Business Unit Portfolio Division