Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Mutual DELETE
Message
 
 
À
26/09/2002 13:38:53
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Titre:
Divers
Thread ID:
00704839
Message ID:
00704851
Vues:
19
How about:

delete from mytable where Num1 = ?nValue and Num1 in
(select Num2 from MyTable where Num1 = ?nValue)

>Hi,
> I would like to delete each time two mutual records in the process.
>for example :
>mytable.dbf
>
>num1 num2
>11111 22222
>33333 44444
>22222 11111
>55555 66666
>77777 88888
>99999 00000
>
>means the 1st record and 3rd record should be deleted from the table,
>
>11111 22222
>22222 11111
>
>Any help in coding will be appreciated.
>PP
Mark McCasland
Midlothian, TX USA
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform