>>>Sure
>>>
>>>"SQL group clause missing or invalid" under engine 90
>>>
>>>Now remember this was just a "first cut" stab at the SQL and I've trried many permutations, including "group by 1, 4"
>>>
>>>

>>>Select JobAct.OurInvID, jobheads.JobID, SUM( jobheads.Quantity) as Booked, SUM( jobact.hours) as Charged, JobHeads.LabourID ;
>>>  from jobact, jobheads ;
>>>  where jobheads.JobID = jobact.JobID ;
>>>  AND jobAct.JobID = "RTvo" ;
>>>  and not EMPTY( JobAct.OurInvID) ;
>>>  group by OurInvID, LabourID ;
>>>  into cursor JobsS
>>>

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

IIRC this was introduced in version 9.