>When I upgrade to VFP 8 this code does not work any more? Does any one have similar problem?
>
>"Select lastname, firstname from Customer union select lastname firstname from employee order by 1 group by Lastname"
>
>it runs fine in VFP 7 but it said "group by invalid or missing" in VFP 8
>
>Thanks.
>
Steve,
You need to include all no-aggregate fields in the GROUP BY clause. You left out firstname. This is covered in the Behavior Changes Since Visual FoxPro 7 sectino of the VFP 8 help.
HTH.
Larry Miller
MCSD
LWMiller3@verizon.netAccumulate learning by study, understand what you learn by questioning. -- Mingjiao