SELECT IM.groupfld AS [Product Group],
IM.category AS [Product Category],
A.product_code AS [Product Code],
IM.descriptionv6 AS [Product Description],
A.asset_code AS [Bar Code Number],
A.description AS [ASSET Description],
A.serial_no AS [Serial #],
A.cost AS [Cost Price],
w.Locn_name AS [Warehouse Location],
H.locn_name AS [Home Location],
A.purdate AS [Purchase Date],
CAST(disposal_amt as decimal(9,2)) AS [Disposal Amount],
disdate AS [Disposal Date]
FROM tblasset01 AS A
LEFT OUTER JOIN tblinvmas AS IM
ON IM.product_code = A.product_code
LEFT OUTER JOIN tblLocnlist W on W.Locn_number = a.locn
LEFT OUTER JOIN tblLocnlist H on H.Locn_number = a.HomeLocn
WHERE A.purdate BETWEEN '2008-01-01' AND '2022-12-31'
ORDER BY IM.groupfld,
IM.category,
A.product_code,
A.asset_code