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!
********************************************************