RE: advanced group by

2005-08-03 Thread Gordon Bruce
Something like this SELECT CompanyName, WhatToShip, SUM(IF(TrackingNumber = '', IF(SerialNumber = '', 1, 0), 0) ) AS READY, SUM(IF(TrackingNumber <> '', IF(SerialNumber = '',

Re: advanced group by

2005-08-03 Thread tony
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