) AS Done
FROM shipments
GROUP BY 1,2
-Original Message-
From: James M. 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
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
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
