Same

>In VFP 6.0 if I wanted to group by ONE fieldname I would type something like this:
>SELECT name_line1, first_name, last_name FROM accounts ;
> WHERE NOT EMPTY(last_name) ;
> GROUP BY name_line1 ;
> ORDER BY last_name INTO ARRAY aClientNames
>
>How do you do it in VFP 8.0?