Summarize query table

Ok, not sure how you are connected to the database in sql, but here’s how i would write this in generic sql.

How are you connected to the database to use SQL? I would love to use that instead of Generic Inquiries

SELECT 
    stats.InventoryID AS ItemID,
    ii.InventoryCD AS ItemName,
    ii.Descr AS ItemDescription,
    SUM(stats.QtyOnHand) AS TotalQuantityOnHand,
    SUM(stats.TotalCost) AS TotalInventoryCost
FROM 
    usrInventoryItem stats
JOIN 
    InventoryItem ii
ON 
    stats.InventoryID = ii.InventoryID
GROUP BY 
    stats.InventoryID, ii.InventoryCD, ii.Descr
ORDER BY 
    ii.InventoryCD;