Re: Query query

[Arthur Fuller]

You should still lose the pointless WHERE 1.
Arthur

On Sun, Dec 4, 2011 at 1:38 AM, Jan Steinman <Jan@stripped> wrote:

> DOH! Brain unfroze, and I realized I needed an aggregate:
>
> SELECT
>    COUNT(lib.Dewey) AS Have,
>    ddn.Dewey AS DDN,
>    ddn.Classification AS Classification
> FROM s_library_dewey ddn
> LEFT OUTER JOIN s_library lib ON ddn.Dewey = FLOOR(lib.Dewey)
> WHERE 1
> GROUP BY ddn.Dewey
>
>