Thanks for your response. I tried grouping by the inventory.itemId instead, but I still am coming up with the same result. Here is the query I am using now:
SELECT
inventory.itemId,
inventory.itemName,
inventory.itemDesc,
inventory.itemPrice,
inventory.itemQty,
inventory.itemSize,
inventory.itemColor,
inventory.partNum,
inventory.prodLine,
orders.OrderDate,
orderdetails.DetailItemId,
orderdetails.DetailQuantity,
(inventory.itemQty*inventory.itemPrice)AS InventoryTotal,
SUM(orderdetails.DetailQuantity)AS OrderUsed,
SUM(orderdetails.DetailQuantity*inventory.itemPrice)AS TotalUsed
FROM
orderdetails
INNER JOIN inventory
ON orderdetails.DetailItemId = inventory.itemId
INNER JOIN orders
ON orderdetails.DetailOrderId = orders.OrderId
GROUP BY
inventory.itemId,
orders.OrderDate
And here is what it is returning:
Speed Reducer catalog CAT03 586 10 2.5 25 1465 Literature
Speed Reducer catalog CAT03 586 25 2.5 62.5 1465 Literature
Speed Reducer catalog CAT03 586 25 2.5 62.5 1465 Literature
Speed Reducer catalog CAT03 586 3 2.5 7.5 1465 Literature
Speed Reducer catalog CAT03 586 2 2.5 5 1465 Literature
Speed Reducer catalog CAT03 586 5 2.5 12.5 1465 Literature
Speed Reducer catalog CAT03 586 2 2.5 5 1465 Literature
Speed Reducer catalog CAT03 586 15 2.5 37.5 1465 Literature
6000 Gearmotors catalog CAT6000 1426 5 2.5 12.5 3565 Literature
6000 Gearmotors catalog CAT6000 1426 10 2.5 25 3565 Literature
6000 Gearmotors catalog CAT6000 1426 3 2.5 7.5 3565 Literature
6000 Gearmotors catalog CAT6000 1426 2 2.5 5 3565 Literature
6000 Gearmotors catalog CAT6000 1426 5 2.5 12.5 3565 Literature
See how it is still displaying each line item separately? Any other suggestions?
Thanks!