murray83
Games Collector
- Local time
- Today, 07:40
- Joined
- Mar 31, 2017
- Messages
- 728
hi i have a little simple SQL code below
which then generates the attached image( have blanked out bits cant show ) what i want is to sum like you would in excel the Qty_On_Hand * Each_Value
have searched here for sum and SQL and drew a blank also have tried looking at google and the quite good https://www.w3schools.com/sql/sql_count_avg_sum.asp
but all that seems to do is count how many records or sum the total of a whole column and i don't want that
any help would be great cheers
Code:
SELECT
inv.Tag_Id , inv.Description , inv.Owner_Id , inv.Sku_Id, inv. Qty_On_Hand, sk.Each_Value
FROM Inventory inv
INNER JOIN SKU sk
ON inv.SKU_ID = sk.SKU_ID
WHERE
Location_Id LIKE 'SUSPENSE'
ORDER BY Pallet_Id DESC
which then generates the attached image( have blanked out bits cant show ) what i want is to sum like you would in excel the Qty_On_Hand * Each_Value
have searched here for sum and SQL and drew a blank also have tried looking at google and the quite good https://www.w3schools.com/sql/sql_count_avg_sum.asp
but all that seems to do is count how many records or sum the total of a whole column and i don't want that
any help would be great cheers