Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Duplicate Entries in 2 different tables
Message
From
11/04/2006 10:46:41
Erick Miranda
Formata Data Business - Grupo Linx
Contagem, Brazil
 
 
To
11/04/2006 01:57:25
Aaron K. Y. Chu
Health & Care Co. Ltd.
Hong Kong, Hong Kong
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
01111888
Message ID:
01112410
Views:
24
Aaron,

>Also, how can I locate duplicated case_no in the same table?

One way is:
Select case_no, Count(*) nTimes;
   From TableName;
   Group By case_no;
   Having Count(*) > 1;
   Into Cursor cursor_duplicated
* Or switch Having for
* Having nTimes > 1
Good Luck!
Erick
Força Sempre!
Strength Always!
Previous
Reply
Map
View

Click here to load this message in the networking platform