Thanks for the help. That cleared some things up.

Charlie

"Plamen Ratchev" <Plamen@SQLStudio.com> wrote in message
news:LLmdncRVeesv2LbVnZ2dnUVZ_t7inZ2d@speakeasy.ne t...
> The logical query processing goes as follows:
>
> 1) FROM - get source data
> 2) WHERE - apply filters to source data
> 3) GROUP BY - create groups
> 4) HAVING - apply filters to groups
> 5) SELECT - select list
> 6) ORDER BY - define order
>
> Once groups are created in step 3, the following steps can reference only
> grouping columns, aggregate functions, or constant expressions. For that
> reason all columns listed in SELECT have to be in GROUP BY.
>
> HTH,
>
> Plamen Ratchev
> http://www.SQLStudio.com