advanced group by

Hello list! little GROUP BY problem here: Table 'shipments' ID int(10) CompanyName char(50) WhatToShip char(50) TrackingNumber char(50) SerialNumber char(50) I would like to obtain the following results: CompanyName - WhatToShip - Ready - Almost - Done Foo

Re: advanced group by

On Wed, 2005-08-03 at 11:59 +0100, James M. Gonzalez wrote: I would like to obtain the following results: CompanyName - WhatToShip - Ready - Almost - Done Foo- car - 26 - 2- 23 Foo-elephant - 43

RE: advanced group by

. Gonzalez [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 03, 2005 5:59 AM To: mysql@lists.mysql.com Subject: advanced group by Hello list! little GROUP BY problem here: Table 'shipments' ID int(10) CompanyName char(50) WhatToShip char(50) TrackingNumber char(50) SerialNumber