I can not get a subquery to work in an Update. I am still having trouble getting this to work.

Thanks

Brenda

>Not having done this in VFP, I'm not sure but, does this work (i.e. I'm not >sure that in VFP SQL you can put an SQL select in the Update's >FilterCondition)?
>
>
UPDATE Customer ;
SET No_Mail = .T. && First posit them all as no mail

* Then set no_mail .F. (allow mail) for the first instance of each customer
* _____________
UPDATE Customer ;
SET No_Mail = .F.;
WHERE Customer.Name in ( Select DISTINCT Name from Customer)
>

>>I have a table that can have multiple records per customer. The customer name is not unique. If there is an exact duplicate on cust_name I do not want to send them multiple mailings. I have a field no_mail that I want to set to .T. for any duplicate cust_name.
>>