Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Select details after child selection
Message
From
13/04/2006 22:28:33
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:
01113354
Message ID:
01113644
Views:
13
Dear Yuri,

After execute the SQL-statement, it seems that it loop infinitely, halt the system?!

After a moment of deep thinking, I use the inner join discuss in Robert Dion's messages!
Finally, I get the answer la...

Thanks for your ideas!
cSQL="select case_no,a.eng_name,dob,address1,address2,address3,address4 from pt_detail a inner join (select eng_name from pt_detail Group By eng_name Having Count(*) > 1) b on a.eng_name = b.eng_name order by eng_name,dob,address4,address3,address2,address1"
Best regards,

Aaron Chu

********************************************************

Working with Visual FoxPro is a lot of FUN!

********************************************************
Previous
Reply
Map
View

Click here to load this message in the networking platform