Re: Lowest 2 items per

> -----Original Message-----
> From: Oliveiros d'Azevedo Cristina
[mailto:oliveiros(dot)cristina(at)marktest(dot)pt]
> Sent: Friday, June 01, 2012 12:28 PM
> To: Relyea, Mike
> Cc: pgsql-sql(at)postgresql(dot)org
> Subject: Re: [SQL] Lowest 2 items per
>
> Yes, you are right, now, thinking about the way I built it, the query,
indeed,
> leaves out the corner case of models which have just one consumable.
>
> I didn't try ur version of the query.
> Does itork now with your improvements ?
> Or were they only gramatical ?
>
> Best,
> Oliver

I only made grammatical changes necessary for the query to function
(adding a missing FROM, fully qualifying "SELECT Make" as " SELECT
subquery2.Make", etc.)
I tried changing the join type to right and left but that did not have
the desired result.

Mike