Hi

"all non aggregate columns" so every field in detail ( I assume there is more than bccode in there)must be in the group by.

Nick Mason

>>Steven,
>>You must include all non-aggregate columns in the GROUP BY clause. You have no aggregate columns so why are using the GROUP BY clause at all?
>>
>>Regards.
>
>Oops, copy/paste-ed the wrong item...same error
>
>

>SELECT Detail.*, count(*) as Total, Codes.desc;
> FROM ;
>     detail ;
>    LEFT OUTER JOIN codes ;
>   ON  Detail.bccode = Codes.code;
> GROUP BY Detail.bccode;
> ORDER BY Detail.bccode
>