OK, that makes more sense but it still doesn't follow the rules. You are only grouping on Detail.bccode. All other fields in Detail as well as Codes.Desc are going to be junk (or could possibly be). See Thread#852868 for more information.

HTH.

>>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
>