Group Summary by Month

2005-07-29 Thread Ed Reed
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

Re: Group Summary by Month

2005-07-29 Thread Rhino
conditions to get only certain part numbers and only certain months. Rhino - Original Message - From: Ed Reed [EMAIL PROTECTED] To: mysql@lists.mysql.com Sent: Friday, July 29, 2005 4:31 PM Subject: Group Summary by Month I have a table that contains all the part number and cost transactions