Inner Join with Sum Aggregate function in SQL Server

Question

I have three tables StockSummary, Item, ItemSpecification. Here I want to join these three tables and to get Sum(StockSummary.Quantity). The main Columns are as follows:

TableA: StockSummary(ItemID, Quantity)
TableB: Item(ItemID, ItemName, SpecificationID)
TableC: ItemSpecification(SpecificationName, SpecificationID)

The desired result should give ItemName, SpecificationName and SUM(Quantity). How to use Aggregate function in Inner Joins?

Alex K. · Accepted Answer · 2011-06-20 12:40:19Z

7

You aggregate the desired column & group by the remainder, the fact that the columns are from the result of a join is not relevant in your case;

select
   b.ItemName,
   c.SpecificationName,
   sum(a.Quantity)
from
   tablea a
   inner join tableb b on b.ItemID = a.ItemID
   inner join tablec c on c.SpecificationID = b.SpecificationID
group by
   b.ItemName,
   c.SpecificationName

answered Jun 20, 2011 at 12:40

Alex K.

177k32 gold badges276 silver badges299 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Inner Join with Sum Aggregate function in SQL Server

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related