> "all non aggregate columns" so every field in detail ( I assume there is more > than bccode in there)must be in the group by.
Yeah, I see that now. It would be quite a drag to articulate all the fields that Detail.* would imply. So since this is old legacy code, I'm opting for the SET ENGINEBEHAVIOR 70 setting to resolve the error rather than correcting code. When writing new code I'll follow the purer SQL rules.
Thanks Nick,
Steven-
>>
>>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
>>