Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
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.
>>
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement