>Thanks a lot, Tore & Naomi,
>
>Actually I do this to avoid grouping by numerically associated field names like 1,2,3 etc. I have got errors before on this count, but none, right now.What could be the reason, for this?
>
>Regards,
>
>Steve
I thought you can not include sub-selects using SET ENGINEBEHAVIOR 70, since it's VFP9 feature, e.g. this type of select statement
select fields left join (select ... ) as additionalSelect is new in 9, if I recall correctly.
For count to work correctly you must include all non-aggregate fields into the GroupBy clause. You may reference fields either by number or by name.
If it's not broken, fix it until it is.
My Blog