List:General Discussion« Previous MessageNext Message »
From:Arthur Fuller Date:December 4 2011 3:42pm
Subject:Re: Query query
View as plain text  
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
>
>

Thread
Query queryJan Steinman4 Dec
Re: Query queryJan Steinman4 Dec
  • Re: Query queryPeter Brawley4 Dec
Re: Query queryJan Steinman4 Dec
  • Re: Query queryArthur Fuller4 Dec
  • Re: Query queryhsv5 Dec
Re: Query queryJan Steinman7 Dec