Hi Borislav
>Yes, you must start thinking like EB=90 :-)
That was the precise reason I had avoided to write the line and change the behavior to 70 or 80 when I was first warned about EB before I converted to VFP9.
>If for PK there is no other combinations and you don't want to expand GROUP BY clause for all other fields which are constant for that PK you could use MAX(), MIN() for those fields to put it in agregate function so you don't have to put them in GROUP BY.
No I would rather not put them in MIN() MAX() for clarity purposes.
Thanks.