What is the Query for this

ramk_1978 · December 19th, 2004, 10:51 AM

hi,

Item Table:
Item Id Item Name
I1 Pencil
I2 Eraser
I3 Pen

Order Item Table:
Order Id Item Id Quantity
O1 I1 20
O2 I1 25
O3 I2 10
O4 I1 10
O5 I3 15

Question is: Query to get Itemwise total quanity.

A.D.Ramkumar

jemacc · December 19th, 2004, 02:41 PM

You can try this

Code:

SELECT     OrderID,ItemID, SUM(Quantity) AS Total_Quantity
FROM         dbo.[Order Details]
GROUP BY OrderID

Jaime E. Maccou

Jonax · December 19th, 2004, 03:14 PM

Itemwise:
GROUP BY ItemId

Jonax · December 19th, 2004, 04:28 PM

SELECT tbItem.ItemId, ItemName, SUM(Quantity) AS Quantity
FROM tbItem INNER JOIN tbOrderItem
ON tbItem.ItemId = tbOrderItem.ItemId
GROUP BY tbItem.ItemId, tbItem.ItemName