From: HaidarPesebe
Date: November 11 2010 9:40am
Subject: Re: backfill results for the same month and year
List-Archive: http://lists.mysql.com/mysql/223570
Message-Id: <008701cb8184$8c354a80$6a0ba8c0@WEBMASTER>
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_NextPart_000_0084_01CB81BF.3606E7F0"

------=_NextPart_000_0084_01CB81BF.3606E7F0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

I've tried it and succeeded. thanks mark

  ----- Original Message -----=20
  From: HaidarPesebe=20
  To: MySQL Lists=20
  Sent: Thursday, November 11, 2010 4:00 PM
  Subject: backfill results for the same month and year


  Dear All,

  I have the following data

  ID CITY      QTY   MONTH YEAR
  -------------------------------
  1  Chigago    10     11       2010
  1  NewYork   22     11       2010
  1  London     54     11       2010
  1  Chigago    7      10       2010
  1  NewYork   26     10       2010
  1  London     33     10       2010

  ID =3D ID PRODUCT.

  How can I backfill results with the same ID by month and year, with =
results like this:

  MONTH/YEAR    QTY TOTAL
  ---------------------------
  11/2010            86
  10/2010            66
  and etc.

  Please help

  Thanks
  haidarpesebe
------=_NextPart_000_0084_01CB81BF.3606E7F0--