>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