Ragnar Hafstaš (gnari) writes: > On Mon, 2005-04-04 at 10:47 +0000, Ragnar Hafstaš wrote: > > On Mon, 2005-04-04 at 12:16 +0200, Michael L. Hostbaek wrote: > > > [problem] > > [slightly broken solution] > > I forgot a FROM clause, and you might want to add a > ORDER BY clause, if that is important: > > select part,mfg, > sum(CASE WHEN eta is NULL then qty ELSE 0 END) as qty, > sum(CASE WHEN eta is NULL then 0 ELSE qty END) as "qty incoming", > max(price) as "highest price", > min(eta) as eta > from thetable > group by part,mfg > order by part,mfg;
Thanks, this works brilliantlty ! /mich ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
