Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Sql to find duplicates
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00811118
Message ID:
00811153
Views:
11
>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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform