>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