Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Check for duplicates
Message
From
07/03/2006 14:39:08
Jerry Tovar
Dana Corporation Dana It
Maumee, Ohio, United States
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Check for duplicates
Environment versions
Visual FoxPro:
VFP 9 SP1
Miscellaneous
Thread ID:
01102167
Message ID:
01102167
Views:
53
Using VFP9, how can I check for the occurrence of a part existing more than once in an order?

The following dataset contains part# 'part2' twice.

order# part#
1 part1
1 part2
1 part3
1 part2
2 part1
2 part2
etc....

I would like to see a query result that states 'part2' is found twice for order# 1. How can I do this?

Thanks,

Jerry
Next
Reply
Map
View

Click here to load this message in the networking platform