I've tried it and succeeded. thanks mark
- Original Message -
From: HaidarPesebe
To: MySQL Lists
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
On 11/11/2010 09:00, HaidarPesebe wrote:
Dear All,
I have the following data
ID CITY QTY MONTH YEAR
---
1 Chigago10 11 2010
1 NewYork 22 11 2010
1 London 54 11 2010
1 Chigago7 10 2010
1 NewYork 26
Dear All,
I have the following data
ID CITY QTY MONTH YEAR
---
1 Chigago10 11 2010
1 NewYork 22 11 2010
1 London 54 11 2010
1 Chigago7 10 2010
1 NewYork 26 10 2010
1 London 33 10
