>Dear all,
>
>I want to select those entries with same english name, then select some other details as follows:
>
>
>

>gnConnHandle=SQLSTRINGCONNECT(lcStringConn)
>
>cSQL="select eng_name,address1,address2,address3,address4 from pt_detail where exist (select eng_name, Count(*) as nTimes from pt_detail Group By eng_name Having Count(*) > 1 b where pt_detail.eng_name = b.eng_name)"
>
>n=SQLEXEC(gnConnHandle, cSQL, "dup_name")
>SQLDISCONNECT(gnConnHandle)
>

>
>I don't know which parts I'm wrong?!

Try this:

cSQL="select eng_name,address1,address2,address3,address4 from pt_detail where eng_name IN (select eng_name from pt_detail Group By eng_name Having Count(*) > 1)"