|
I am trying to write a query to return how many items were sold in particular months. Right now its returning the same item multiple times per month. I just want each ItemID returned once per month with the Amtsold summed for the whole month per item.
(comments are locked)
|
|
Just remove AmtSold from the group by list You probably mean "remove AmtSold".
Oct 14 '11 at 12:06 AM
Håkan Winther
Thanks Hakan!
Oct 14 '11 at 12:16 AM
Cyborg
(comments are locked)
|

