Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Sql to find duplicates
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00811118
Message ID:
00811153
Vues:
12
>Thank you. It's clearer and works but I needed another thing...
>What you gave me shows the duplicate record and the times it's duplicated, but I was trying to get the duplicate records, record by record. So that each record is listed.
>Thanks,
>Allen


What Sergey offered, is a standard way to find duplicates. You could easily do a Set Relation to lineitems_id into your detail lineitems table and get each record, or you could do a second query for all lineitems_id in the duplicates cursor you got.


Alex Feldstein, MCP, Microsoft MVP
VFP Tips: English - Spanish
Website - Blog - Photo Gallery


"Once again, we come to the Holiday Season, a deeply religious time that each of us observes, in his own way, by going to the mall of his choice." -- Dave Barry
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform