I have a table that contains all the part number and cost transactions over
time. I wanna get a get the summary cost of each part number for each month.
For example, when I supply a single part number to this query the results
should be something like this.
+----------+----------+
| Month | Cost |
+----------+----------+
| Oct 04 | 19521.00 |
| Nov 04 | 854.00 |
| Dec 04 | 191.00 |
| Jan 05 | 7015.00 |
| Feb 05 | 21.00 |
| Mar 05 | 25.00 |
| Apr 05 | 13571.00 |
| May 05 | 1015.00 |
+----------+----------+
Can anyone point me in a direction to start on this?
