Probably an easy one, need help with a Where clause

Question

Viewing 2 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

blast2hell Right there with Babe Points: 771 More actions · Answer 1

Ok I think I figured out what I need...

@Inst_ID int,

@status char(1)

SELECT

Inventory.Car,

Inventory.StockNumber,

SUM(InventoryService.FinalCost) As TotalCost

FROM Inventory

LEFT JOIN InventoryService ON Inventory.Inventory_ID = InventoryService.Inventory_ID

WHERE

Inventory.Inst_ID = @Inst_ID AND

Inventory.Status LIKE @status

GROUP BY Inventory.Car, Inventory.StockNumber

HAVING SUM(InventoryService.Finalcost) > 0.00

David Paskiet SSCrazy Points: 2949 More actions · Answer 2

Sometimes it just comes to you. ANy aggreagate function that needs to be in the GROUP BY will need to have it's criteria in the HAVING clause.:hehe:

Kindest Regards,
David

** Obstacles are those frightening things that appear when we take our eyes off the goal. **