Re: removing duplicates and giving average of other field.

2004-08-12 Thread Michael Stassen
new g2d table is what you want you can safely drop your g2d_old table. HTH, Lachlan -Original Message- From: Jeroen Van Goey [mailto:[EMAIL PROTECTED] Sent: Wednesday, 11 August 2004 9:16 PM To: [EMAIL PROTECTED] Subject: removing duplicates and giving average of other field. Hi again

RE: removing duplicates and giving average of other field.

2004-08-11 Thread Lachlan Mulcahy
ED] Sent: Wednesday, 11 August 2004 9:16 PM To: [EMAIL PROTECTED] Subject: removing duplicates and giving average of other field. Hi again, thanks for the quick reply on my previous question, the solution given by Michael Stassen worked like a charm. But now I've again run into a situat

removing duplicates and giving average of other field.

2004-08-11 Thread Jeroen Van Goey
Hi again, thanks for the quick reply on my previous question, the solution given by Michael Stassen worked like a charm. But now I've again run into a situation where I'm stuck with my limited knowledge of MySQL. Given the table: mysql> select * from g2d; +---+--+--+--