>>>What exactly IS VFP 9's problem with this (remember I've only been using 9 for 2 months now)
>>
>>This query also needs a group by
jobheads.JobID. All fields which are not in aggregate function MUST be listed in GROUP BY. So, the rule is very simple: either field should be one of the aggregate functions (MIN, MAX, AVG, COUNT, SUM) or it should be in GROUP BY list of the fields.
>
>Thanks. That's how I read it in Help but didn't think it meant you had top have ALL non-agg fields. Is this new to 8/9 cos I don't recall having to do this in the past - I thought only the fields you wanted,say, a printing group header break on?
Yes, this is new in VFP8 and VFP9 and this is ANSI SQL standard. It should be documented in Help under SET ENGINEBEHAVIOR.
If it's not broken, fix it until it is.
My Blog