Query syntax mistake

Question

SELECT Sum(tblWarehouseItem.whiQty) AS Sum,
tblWarehouseItem.whiItemName
FROM tblWarehouseItem
WHERE tblWarehouseItem.whiActive =True 
AND tblWarehouseItem.whiCansel=False 
AND tblWarehouseItem.whiExpiryDate Is Null
GROUP BY tblWarehouseItem.whiItemName, tblWarehouseItem.whiQty

if you please help me i am confused...

i have the above Query.

For example in my table i have:

whiItemName   whiQty(sum)
Fuel          100
Fuel          100
Fuel          100

I wlould like the output to be:

whiItemName   whiQty(sum)
Fuel          300

paul · Accepted Answer · 2014-10-07 13:00:45Z

4

You have an extra column in your GROUP BY

You just need:

SELECT Sum(tblWarehouseItem.whiQty) AS Sum,
tblWarehouseItem.whiItemName
FROM tblWarehouseItem
WHERE tblWarehouseItem.whiActive =True 
AND tblWarehouseItem.whiCansel=False 
AND tblWarehouseItem.whiExpiryDate Is Null
GROUP BY tblWarehouseItem.whiItemName

answered Oct 7, 2014 at 13:00

paul

22.1k1 gold badge56 silver badges54 bronze badges

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

Comments

John Babb · Accepted Answer · 2014-10-07 13:04:10Z

0

The short of it is you need to remove the tblWarehouseItem.whiQty from the group by. I'm not sure what you are doing with the where condition but you also might try as a having keyword. The statement below will illustrate the point.

SELECT tblWarehouseItem.whiItemName, Sum(tblWarehouseItem.whiQty) AS Sum FROM tblWarehouseItem GROUP BY tblWarehouseItem.whiItemName

answered Oct 7, 2014 at 13:04

John Babb

95110 silver badges19 bronze badges

Collectives™ on Stack Overflow

Query syntax mistake

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related