Geoff,
I highly recomend to read what's new section in VFP8 and VFP9 help. VFP8 help is available online.
>
>I guess I can expect to miss a few things when I jump a whole version.
>
>Geoff
>
>>Hi Geoff,
>>
>>See
Re: Change in SQL commands! Message #
941774. The problem with you select is that yo didn't specify from wich record in a group values for i_key, and contractor should come. If they are the same for all records in a group, yopu can include them into GROUP BY clause. If you don't care from wich record those values comes, you can wrap those fields into MIN or MAX function. The solution depends on what result you want to get for those two fields.
--sb--