You should still lose the pointless WHERE 1. Arthur On Sun, Dec 4, 2011 at 1:38 AM, Jan Steinman <j...@bytesmiths.com> 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 > >