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.