I don't know. Maybe I put it in the wrong spot? I thought maybe the group by was just applying to one of the selects and not the whole union. At any rate, it didn't eliminate the duplicates.

Thanks,

Michelle

>I have no idea why this didn't work for you - I use GROUP BY all the time; sometimes to select only a few records out of many (i.e., eliminate duplicates).
>
>Please note that Visual FoxPro might select some random record for the fields that are not unique!
>
>Hilmar.